Page 1 of 1
job name from pid
Posted: Sun Aug 23, 2009 5:51 am
by 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 ?
Posted: Sun Aug 23, 2009 6:45 am
by 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.
Posted: Mon Oct 19, 2009 4:22 am
by 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 ?
Posted: Mon Oct 19, 2009 4:30 am
by ArndW
umm..
Code: Select all
SELECT JOBNO, CATEGORY FROM DS_JOBS WHERE NAME = 'MyJobName';