Job Details
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 132
- Joined: Wed Mar 01, 2006 11:12 pm
- Location: Pune
Job Details
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
SMB
-
- Participant
- Posts: 612
- Joined: Thu May 03, 2007 4:59 am
- Location: Melbourne
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
Command line -
dsjob -ljobs <Project>
or
$DSHOME/bin/uvsh "select * from DS_JOBS" > /FileName.txt
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.