DSXchange

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?

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;

Run dsjob command from unix shell with appropriate parameters.

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

dsjob -ljobs <Project NAME>

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

dsjob -ljobs <Project NAME>

That's a great tip. Thanks Nani.

nani0907 wrote: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"

Check whether your PATH includes bin of datastage.

You need to run from $DSHOME folder

srai wrote:

nani0907 wrote: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...

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

robjones wrote: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 ?

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.