How to find the Sequence for the particular job
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 24
- Joined: Mon Jul 24, 2006 12:30 am
How to find the Sequence for the particular job
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
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
Ramakrishna
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
I'm confident that someone here has done it thru a back door.....
Ernie
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
-
- Participant
- Posts: 597
- Joined: Fri Apr 29, 2005 6:19 am
- Location: Singapore
-
- Participant
- Posts: 597
- Joined: Fri Apr 29, 2005 6:19 am
- Location: Singapore
Re: How to find the Sequence for the particular job
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.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'.
This may not be efficient but definitely painless in a 'development completed' environment.
Kandy
_________________
Try and Try again…You will succeed atlast!!
_________________
Try and Try again…You will succeed atlast!!
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
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
...but isn't the original question the "opposite?" ....ie...given Job X, tell me the Sequences that invoke it?
Ernie
Ernie
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
Re: How to find the Sequence for the particular job
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.
-
- Participant
- Posts: 24
- Joined: Mon Jul 24, 2006 12:30 am
-
- Participant
- Posts: 24
- Joined: Mon Jul 24, 2006 12:30 am
Re: How to find the Sequence for the particular job
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
Ramakrishna
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.eostic wrote:...but isn't the original question the "opposite?" ....ie...given Job X, tell me the Sequences that invoke it?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers