DSXchange

Hi All,

I would like to know how many jobs available in Datastsge project.
How to import all job names from a datastage project .
I am using Datastsge 7.5 and OS Unix.
Is any option available in Datastage 7x to get all job names at a time, without manually.

Thank you,
:D

you can get all jobnames using the command dsjob -ljobs ....this will display all jobs within a particular project .

Hi Siva,

dsjob -ljobs <Projectname>
then you will get your project jobs in list .

In Director go to the View menu and disable display of categories/folders.
The count of job names will be in the status bar, and the display will contain a list of all jobs, which you can sort based on any of the column headings. You can then use Director's report printing facilities if you wish; these include the ability to "print" to file.

Any way you can have a DS job do that ?

The DS_JOBS hashed file can be accessed from server jobs or from the TCL command line (which in turn can be called from execute command stage in a sequence job, for example). The SQL syntax would be
"SELECT COUNT(*) FROM DS_JOBS WHERE JOBTYPEIND NE '';"

Addendum - I read your post that you only wanted the count, but you can modify the SQL above to get the list of job NAMEs as well.

Hi Arn

Thanks for the swift reply

It was actually an extract similar to
Log on to #project# in DS Director -> Uncheck Show Categories -> Project Print -> summary only and print to file -> Define File Location

This way we could have an automated extract for the Job names in a given DS Project for customer so she can validate the content.
We run this for Pharma companies and have a ridiculously level of documentation


Brgds Jan

EDIT: We run it on Windows