Hi,
Anybody please let me know how to find a jobs in a sequence through the unix scripts.
how to find a sequence names in project level through the script.
Thanks,
sujatha
how to find a job names in a sequence through script
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 7
- Joined: Mon May 12, 2008 5:57 am
- Location: near BEML gate
Hi,
Finding the location of any job inside the project in versions prior to 8
is done by querying the project's repository.
This is done by commands you run from the DataStage Administrator.
Type this sql and hit the execute button:
in the returned data you can find the category it is under, you can also select only the category field from DS_JOBS if you like
If your running 8 version or later you have the find utility inside the tool wich wil help you find the location of any component.
IHTH (I Hope This Helps),
Finding the location of any job inside the project in versions prior to 8
is done by querying the project's repository.
This is done by commands you run from the DataStage Administrator.
Type this sql and hit the execute button:
Code: Select all
SELECT * FROM DS_JOBS WHERE NAME LIKE '%JOBNAME%';
If your running 8 version or later you have the find utility inside the tool wich wil help you find the location of any component.
IHTH (I Hope This Helps),
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
![Image](http://www.worldcommunitygrid.org/images/logo.gif)
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
![Image](http://www.worldcommunitygrid.org/images/logo.gif)
To find the jobs contained in a certain Sequence, pretty sure you would use the DSSEARCH command for that. An exact search here for that should turn up the gory details.
Last edited by chulett on Wed Nov 30, 2011 2:55 pm, edited 1 time in total.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
There are two questions, and it's not clear which one you're asking.
- What are the names of the jobs that are designed into a sequence (whether or not they are actually run when the sequence executes?
What are the names of the jobs that are actually executed by a particular run of the sequence?
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.