PX 6.0:-
We prepared a sequencer which internal calls 5 PX jobs. Whenever a job is complete status other "warning" and "ok" we stop calling next jobs from that sequence. This works fine.
There are such 4 sequencers in all. All these 4 sequencers are called from a main sequencer. Now we found out in Main sequencer, when first sequencer is running if any jobs refereed in that first sequencer fails next jobs from that first sequencer are not called, But first sequencer is completed with status "OK" and sequencer 2 is called. We do not want any of the following sequencers to be called if any of the internal jobs fails.
Any pointers to this are most welcome.
Thanks,
Nitin
Sequencer issue in PX
Moderators: chulett, rschirm, roy
Hi,
We had a similar problem some time ago. If I understand your problem: Your sequencer finishes fine (status = OK) even if a job inside aborts. This is normal because the sequencer is not affected by the ending status of included jobs. What we did was use a routine after each sequencer to scan the sequencer's logs looking for indication of a failed job. If a job has failed, we log a fatal entry into the main sequencer. This stops the execution of the sequencer running your lower sequences.
I don't know if this it what you are looking for but I could tell you more if you want more specific details.
Mat
We had a similar problem some time ago. If I understand your problem: Your sequencer finishes fine (status = OK) even if a job inside aborts. This is normal because the sequencer is not affected by the ending status of included jobs. What we did was use a routine after each sequencer to scan the sequencer's logs looking for indication of a failed job. If a job has failed, we log a fatal entry into the main sequencer. This stops the execution of the sequencer running your lower sequences.
I don't know if this it what you are looking for but I could tell you more if you want more specific details.
Mat
-
- Participant
- Posts: 21
- Joined: Wed Oct 01, 2003 11:53 am
Hi Nitin,
Here's how we run our sequences:
1. We build a first sequencer with the jobs we want to run.
2. We make another sequencer containing only two routines. the first one runs the sequencer #1 (setting the parameters, gathering stats, etc.) The second one waits for the first sequencer to end and then scans it's log for warnings and aborts in infos entries about jobs. If it encountered any aborted stauts, it will log a fatal entry into the master sequence to stop it.
DataStage Basic provides you with every DS functions you need for this.
If you want, write me in private and I will send you a couple of routines. The comments inside are in french but the code should be clear enough. It might even save you a couple days of coding
Regards
Mat
Here's how we run our sequences:
1. We build a first sequencer with the jobs we want to run.
2. We make another sequencer containing only two routines. the first one runs the sequencer #1 (setting the parameters, gathering stats, etc.) The second one waits for the first sequencer to end and then scans it's log for warnings and aborts in infos entries about jobs. If it encountered any aborted stauts, it will log a fatal entry into the master sequence to stop it.
DataStage Basic provides you with every DS functions you need for this.
If you want, write me in private and I will send you a couple of routines. The comments inside are in french but the code should be clear enough. It might even save you a couple days of coding
Regards
Mat
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: