Job Details

baglasumit21 · Post by **baglasumit21** » Fri Jun 08, 2007 3:39 am

I want to get the list of all jobs in Datastage in a sequential file. Please let me know what command to run. or is there any way to achieve it through a datastage job itself

JoshGeorge · Post by **JoshGeorge** » Fri Jun 08, 2007 4:42 am

From a Job use DSGetProjectInfo function with = DSJ.JOBLIST and link this output to a file.
Command line -
dsjob -ljobs <Project>
or
$DSHOME/bin/uvsh "select * from DS_JOBS" > /FileName.txt

ray.wurlod · Post by **ray.wurlod** » Fri Jun 08, 2007 8:33 am

In a job create a single Varchar column called NAME. Mark it as key. Use a UniVerse or Hashed File stage to read from DS_JOBS. Constrain so that you only get names beginning with other than "\" or "/" - these are control records, recording the existence of categories and the next available job number.

mujeebur · Post by **mujeebur** » Sat Jun 09, 2007 8:40 pm

You can also query by using ds command 'dssearch'