Page 1 of 1
List all jobs from command line (v6)?
Posted: Tue Feb 14, 2006 8:20 am
by rlewis
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?
Re: List all jobs from command line (v6)?
Posted: Tue Feb 14, 2006 8:26 am
by manojkumarnayak
you can use "dsjob" command
regards
manoj
Posted: Tue Feb 14, 2006 1:48 pm
by rlewis
Unfortunately, I don't have a dsjob.exe installed on my Windows client. Is that something that is part of a standard install for datastage v6?
Or...is that only available from the Unix server?
Posted: Tue Feb 14, 2006 9:55 pm
by kduke
It is on your server. Copy it to the client.
Posted: Thu Feb 16, 2006 10:24 am
by rlewis
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
Posted: Thu Feb 16, 2006 12:37 pm
by kduke
Do a search for TCL commands or DS_JOBS.
Posted: Thu Feb 16, 2006 4:00 pm
by ray.wurlod
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