How can we list out all the jobs present in a DataStage Proj
Moderators: chulett, rschirm, roy
How can we list out all the jobs present in a DataStage Proj
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?
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?
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 251
- Joined: Mon Jun 09, 2008 5:52 am
Set the dsenv and then run the command..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"
Go to ../../I*/I*/S*/DSE* then . ./dsenv.. then you should be able to run the command...
Regards,
Ganesh
Ganesh
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Code: Select all
DSHOME=`cat /.dshome` ; export DSHOME
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.
-
- Participant
- Posts: 1
- Joined: Mon Jan 11, 2010 12:09 am
Universe shell need help
Hi robjones thanks for the reply but need help on universal Shell --- how can we run the query from Unix ?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;
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
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.