Page 1 of 1
How to find the Sequence for the particular job
Posted: Tue Jan 27, 2009 6:56 am
by 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
Posted: Tue Jan 27, 2009 7:07 am
by 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
Posted: Tue Jan 27, 2009 8:52 am
by 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.
Posted: Tue Jan 27, 2009 10:30 am
by 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.
Posted: Tue Jan 27, 2009 10:36 am
by 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.
Posted: Tue Jan 27, 2009 11:12 am
by 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
Posted: Tue Jan 27, 2009 11:59 am
by kandyshandy
u need to give the job name ..
I am sure that you will get a formal reply from someone
Re: How to find the Sequence for the particular job
Posted: Tue Jan 27, 2009 12:09 pm
by kandyshandy
ramudwhelp wrote: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.
Posted: Tue Jan 27, 2009 2:12 pm
by 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
Posted: Tue Jan 27, 2009 10:32 pm
by eostic
...but isn't the original question the "opposite?" ....ie...given Job X, tell me the Sequences that invoke it?
Ernie
Re: How to find the Sequence for the particular job
Posted: Tue Jan 27, 2009 11:10 pm
by 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.
Posted: Wed Jan 28, 2009 6:28 am
by ramudwhelp
Yes Ernie - I want that way
For Give job 'X' find the sequence that invokes it.
Re: How to find the Sequence for the particular job
Posted: Wed Jan 28, 2009 6:44 am
by 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
Posted: Wed Jan 28, 2009 7:27 am
by chulett
eostic wrote:...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.