Can we find all the job names, which use a specific dataset.

[sendmkpk]

Can we find all the job names, which use a specific dataset.

sth like(for job name)
SELECT CATEGORY FROM DS_JOBS WHERE NAME = 'JobSeq_Prod'

[AmeyJoshi14]

You can get this in the following link:

viewtopic.php?t=115460&highlight=

This link is quite similar to your question...

If your stage name is same to your dataset name..then you can use a tidious method....that is writing script which will use most of the commands from "dsjob"
If the above conditions (stagename in job= dataset name) and if you want i will develop the script and will give it to you...

Waiting for DSGurus suggestions......

[ray.wurlod]

Export the project and search in the DSX/XML file. Or query the Repository.

Code: Select all

SELECT NAME FMT '40L' FROM DS_JOBS 
WHERE JOBNO IN (
   SELECT OBJIDNO FROM DS_JOBOBJECTS 
   WHERE OLETYPE = 'CCustomInput' 
   AND EVAL "@RECORD<14,1>" = 'dataset' 
   AND EVAL "@RECORD<15,1>" LIKE '%<<Data Set name>>'
) ;

[sendmkpk]

Thanks ray,

Code: Select all

SELECT NAME FMT '40L' FROM DS_JOBS 
WHERE JOBNO IN (
   SELECT OBJIDNO FROM DS_JOBOBJECTS 
   WHERE OLETYPE = 'CCustomInput' 
   AND EVAL "@RECORD<14,1>" = 'dataset' 
   AND EVAL "@RECORD<15,1>" LIKE '%<<Data Set name>>'
) ;

ray,

Can you guide me on the DataStage Repository(what is the table description of DS_JOBS, what key info each column holds ) and few other tables which hold key information.

to some, me to a doc/pdf or sth,

thanks to anyone who can answer.

[ArndW]

These internal tables (actually, hashed files) are not officially documented anywhere. If you look thorugh this site you will find some references and descriptions - more than you would get from Ascential/IBM.

[chucksmith]

Try my List all files and tables used by jobs and routines in a dsx file. You will find it on the DataStage Tools page of www.anotheritco.com .

It understands all server passive stages, and has limited understanding of the following parallel stages: SequentialFile, FileSet, DataSet, LookupFileSet, sqlsvr, DRS, andOracle.

[sendmkpk]

thanks, chuk

this is of some use.