Hi,
I've seen a few backup type scripts which start with the list of objects in a text file. Is there a way to get that list of jobs/functions from the command line in datastage v6?
List all jobs from command line (v6)?
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 21
- Joined: Fri Nov 04, 2005 11:31 am
Re: List all jobs from command line (v6)?
you can use "dsjob" command
regards
manoj
regards
manoj
I found it on our Unix server. Thank you.
Another quick question...The list as output from this command does not include the "container hierarchy" that the designer shows. Is it possible to output each job's hierarchy as part of the listing?
For example:
Job: somejob
Contained in: \myjobs\production
Output I'd like to see from the job listing:
\myjobs\production\somejob
Another quick question...The list as output from this command does not include the "container hierarchy" that the designer shows. Is it possible to output each job's hierarchy as part of the listing?
For example:
Job: somejob
Contained in: \myjobs\production
Output I'd like to see from the job listing:
\myjobs\production\somejob
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Code: Select all
. $DSHOME/dsenv
cd ProjectDirectory
stmt="SELECT NAME,CATEGORY FROM DS_JOBS WHERE NAME NOT LIKE '\\%' ORDER BY CATEGORY,NAME;"
$DSHOME/bin/uv $stmt > jobs_by_category
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.