Getting Job name and description for all job components

[suneyes]

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..

[ray.wurlod]

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.

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';