List all jobs from command line (v6)?

[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?

[manojkumarnayak]

you can use "dsjob" command

regards
manoj

[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?

[kduke]

It is on your server. Copy it to the client.

[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

[kduke]

Do a search for TCL commands or DS_JOBS.

[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