How to find the Sequence for the particular job

[ramudwhelp]

Hi,


In my project i have 'N' no. of Jobs and 'M' no of sequences bult for the jobs. Now my question is How can i find the Sequence Name for the particular job 'X'.

Thanks in advance

[eostic]

hmm... Well, in 8.x this relationship is immeidately visible graphically in the Metadata Workbench via the "Sequenced By" relationship (or "Sequenced Jobs" when viewing the Sequence itself). Not sure of the best way to do this in 7.x except via access to Universe.....

I'm confident that someone here has done it thru a back door.....

Ernie

[chulett]

Or there's always the front door. Open the Sequence job / Job Properties / Dependencies tab for a list of all the jobs the Sequence runs.

[Pierre]

Craig wrote

Or there's always the front door. Open the Sequence job / Job Properties / Dependencies tab for a list of all the jobs the Sequence runs.

Yes, but not necessary in the order the sequence they run
Am I right ?

Pierre.

[chulett]

From what I recall it is the order they were added to the Sequence, which more than likely is the order they run in but may not be.

[mk_ds09]

there is command dssearch..
it searches specific job used in the given number of seqeunces.

check out the parameters..
u need to give the job name ..
and the category..

once this is given, it will show the name of sequences in which the job is used..

----------

Hope this helps

---------

MK

[kandyshandy]

u need to give the job name ..

I am sure that you will get a formal reply from someone

[kandyshandy]

In my project i have 'N' no. of Jobs and 'M' no of sequences bult for the jobs. Now my question is How can i find the Sequence Name for the particular job 'X'.

If you don't want to open sequences one by one and look for your job.... and if you are familiar with DSX export data, just export all sequences and search for the particular job name in question. Then scroll up little bit to find what you want.

This may not be efficient but definitely painless in a 'development completed' environment.

[chulett]

Perhaps something like this...

Code: Select all

select 
   DS_JOBS.NAME SequenceName FMT '40L'  
from 
   DS_JOBOBJECTS, DS_JOBS 
where EVAL DS_JOBOBJECTS."@RECORD<3>" = 'YourJobNameGoesHere'
  and EVAL DS_JOBOBJECTS."@RECORD<2>" = 'CJSJobActivity' 
  and DS_JOBOBJECTS.OBJIDNO = DS_JOBS.JOBNO

[eostic]

...but isn't the original question the "opposite?" ....ie...given Job X, tell me the Sequences that invoke it?

Ernie

[jib]

If the job has run once then the job log also mentions the sequence name as the DSJobController = the Sequence name. This helps only if you are looking for one/two of few jobs.

[ramudwhelp]

Yes Ernie - I want that way

For Give job 'X' find the sequence that invokes it.

[ramudwhelp]

Hi jib - Thanks for response, If the job ran atleast once then we can find the respective sequence with DSJobController , thats is the good option....Thank you

[chulett]

...but isn't the original question the "opposite?" ....ie...given Job X, tell me the Sequences that invoke it?

The opposite of what - what I posted? Did anyone try it? That sure as heck is what I *thought* it did, heck I even tested it for frak's sake.