DSXchange

Posted: **Mon May 21, 2012 10:15 pm**

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

Posted: **Tue May 22, 2012 3:44 am**

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

DSXchange

Getting Job name and description for all job components

Getting Job name and description for all job components