Page 1 of 1
how to find a job names in a sequence through script
Posted: Wed Nov 30, 2011 10:49 am
by sujatha dasa
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
Posted: Wed Nov 30, 2011 11:59 am
by roy
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:
Code: Select all
SELECT * FROM DS_JOBS WHERE NAME LIKE '%JOBNAME%';
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),
Posted: Wed Nov 30, 2011 12:08 pm
by chulett
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.
Posted: Wed Nov 30, 2011 1:06 pm
by ray.wurlod
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?
These are answered in different ways.