how to find a job names in a sequence through script

sujatha dasa · Post by **sujatha dasa** » Wed Nov 30, 2011 10:49 am

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

roy · Post by **roy** » Wed Nov 30, 2011 11:59 am

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),

chulett · Post by **chulett** » Wed Nov 30, 2011 12:08 pm

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.

ray.wurlod · Post by **ray.wurlod** » Wed Nov 30, 2011 1:06 pm

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.