Hi,
I am trying to to pull out the list of datastage jobs and its description to a report.
Is there any easy way of doing it..
All I want is
Job Name ,Description
JOB1,Job to perform Delta operation..
Getting Job name and description for all job components
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Probably easiest to do in Director client (Project > Print > Print to File) with display of categories suppressed.
That information is also contained in DS_JOBS and DS_JOBOBJECTS tables; you could create your report from those.
That information is also contained in DS_JOBS and DS_JOBOBJECTS tables; you could create your report from those.
Code: Select all
SELECT DS_JOBS."NAME", DS_JOBOBJECTS."DESC"
FROM DS_JOBS, DS_JOBOBJECTS
WHERE DS_JOBS.JOBNO = DS_JOBOBJECTS.OBJIDNO
AND DS_JOBOBJECTS.@ID LIKE '%ROOT';
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.