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 ?
job name from pid
Moderators: chulett, rschirm, roy
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:
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.
Code: Select all
SELECT NAME, CATEGORY FROM DS_JOBS WHERE JOBNO = 'nnn';
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Premium Member
- Posts: 87
- Joined: Sat Jul 14, 2007 2:24 pm
umm..
Code: Select all
SELECT JOBNO, CATEGORY FROM DS_JOBS WHERE NAME = 'MyJobName';
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>