how to get jobs names from Datastage project.

esivaprasad · Post by **esivaprasad** » Wed May 27, 2009 5:21 am

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

nagarjuna · Post by **nagarjuna** » Wed May 27, 2009 5:41 am

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

fareeda_b · Post by **fareeda_b** » Wed May 27, 2009 6:48 am

Hi Siva,

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

ray.wurlod · Post by **ray.wurlod** » Wed May 27, 2009 4:32 pm

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.

jinm · Post by **jinm** » Tue Oct 20, 2009 3:05 am

Code: Select all

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 ?

ArndW · Post by **ArndW** » Tue Oct 20, 2009 3:44 am

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.

jinm · Post by **jinm** » Tue Oct 20, 2009 4:12 am

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