job name from pid

[asaf_arbely]

I want to get the job name and project name from the pid or DSnum
Any idea in which table in the repository this kind of information is stored ?

[chulett]

If 'DSnum' is the internal job number used in all on the control structures names (like the 'nnn' in RT_LOGnnn) then you can query that from DS_JOBS:

Code: Select all

SELECT NAME, CATEGORY FROM DS_JOBS WHERE JOBNO = 'nnn';

Going back to it from the PID is another kettle of fish, not sure off the top of my head and not somewhere where I can... experiment.

[asaf_arbely]

do you know of a way to do it the other way around ? i meen to get the jobnumber from the job name ?

[ArndW]

umm..

Code: Select all

SELECT JOBNO, CATEGORY FROM DS_JOBS WHERE NAME = 'MyJobName';