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
how to get jobs names from Datastage project.
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 135
- Joined: Tue Dec 09, 2008 10:35 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
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.
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.
"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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
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
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