How can we list out all the jobs present in a DataStage Proj

[srai]

Hi All

How can we list out all the jobs present in a DataStage Project?
Are any way there to generate an excel/doc containing all the job names in a particular project?

[robjones]

If you're familiar with the Universe shell, you can query the DS_JOBS table to find what you need.

You'd simply need to use:

SELECT NAME FROM DS_JOBS;

[arvind_ds]

Run dsjob command from unix shell with appropriate parameters.

[nani0907]

here is the command line prompt to get list of JObs.

dsjob -ljobs <Project NAME>

[robjones]

here is the command line prompt to get list of JObs.

dsjob -ljobs <Project NAME>

That's a great tip. Thanks Nani.

[srai]

here is the command line prompt to get list of JObs.

dsjob -ljobs <Project NAME>

Hi,

I tried running the above mentioned commond from UNIX prompt
but getting message as

"-bash: dsjob: command not found"

[Sainath.Srinivasan]

Check whether your PATH includes bin of datastage.

[srinivas.g]

You need to run from $DSHOME folder

[dganeshm]

here is the command line prompt to get list of JObs.

dsjob -ljobs <Project NAME>

Hi,

I tried running the above mentioned commond from UNIX prompt
but getting message as

"-bash: dsjob: command not found"

Set the dsenv and then run the command..

Go to ../../I*/I*/S*/DSE* then . ./dsenv.. then you should be able to run the command...

[chulett]

This is version 7, not 8 so the path is not quite so 'complex'. Simplest solution is to cd to the $DSHOME/bin directory and run dsjob with a "dot slash" in front of it:

./dsjob -ljobs etc etc

[ray.wurlod]

Code: Select all

DSHOME=`cat /.dshome` ; export DSHOME

[ranabrata_r]

If you're familiar with the Universe shell, you can query the DS_JOBS table to find what you need.

You'd simply need to use:

SELECT NAME FROM DS_JOBS;

Hi robjones thanks for the reply but need help on universal Shell --- how can we run the query from Unix ?

[ray.wurlod]

Welcome aboard.

On DSXchange we encourage posters to Search for solutions; typically you are not the first with any particular question.

Secondly, we discourage hijacking other people's threads. You need to start a new thread (assuming that your search is unsuccessful) on how to invoke the DataStage shell.