Job Sequencer process

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
denzilsyb
Participant
Posts: 186
Joined: Mon Sep 22, 2003 7:38 am
Location: South Africa
Contact:

Job Sequencer process

Post by denzilsyb »

Hallo all

If we have a MASTERCONTROL (Sequencer) controlling a series of JOBSEQUENCERS which in turn control individual jobs, we sit with the following problem:

If an individual job fails, the JOBSEQUENCER finishes OK and the MASTERCONTROL that sms's us says that all the jobs are finished OK. which is, well, bull.

Is there any way to crash a JOBSEQUENCER from the underlying job so that the MASTERCONTROL can inform us of the correct status of the run? Or is there any advice.

thanks
dnzl
"what the thinker thinks, the prover proves" - Robert Anton Wilson
jeredleo
Participant
Posts: 74
Joined: Thu Jun 19, 2003 8:49 am

Post by jeredleo »

We created a routine to fail the sequencer if any executed jobs fail. So you would set up a Sequence stage in your lower sequencers that collects 'ANY' job failures that will then run this job failure routine. The only thing we have in the code is below with an argument to pass in a failure message

Call DSLogFatal(FatalMessage,"Rejects Link")

Ans = 0


Otherwise if you have DS 7.5 look into setting up your job with restartability and all your controlling sequencers with 'abort' when you want them to.

JB
kduke
Charter Member
Charter Member
Posts: 5227
Joined: Thu May 29, 2003 9:47 am
Location: Dallas, TX
Contact:

Post by kduke »

This also works in Ds7.1 but no earlier releases.
Mamu Kim
gh_amitava
Participant
Posts: 75
Joined: Tue May 13, 2003 4:14 am
Location: California
Contact:

Post by gh_amitava »

Hi,

To control your job you need to write Job control routine.

Regards
Amitava
Post Reply