Recompiling aborted job in sequence automatically

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
saviop
Participant
Posts: 4
Joined: Thu Sep 07, 2006 1:18 am

Recompiling aborted job in sequence automatically

Post by saviop »

Hi,

We have a series of jobs in a sequence. We have a requirement that if any job aborts, the aborted job should recompile(or reset) without any manual intervention.

Pls help.

Thnx,
Savio
DS_SUPPORT
Premium Member
Premium Member
Posts: 232
Joined: Fri Aug 04, 2006 1:20 am
Location: Bangalore

Post by DS_SUPPORT »

You are having an option "Reset If required, then run" in the execution Action, Choose that option. It will reset the job.
kris
Participant
Posts: 160
Joined: Tue Dec 09, 2003 2:45 pm
Location: virginia, usa

Re: Recompiling aborted job in sequence automatically

Post by kris »

saviop wrote: We have a requirement that if any job aborts, the aborted job should recompile(or reset) without any manual intervention.
Hi Saviop,

How are you calling these jobs? From shell scripts or sequencer jobs?

If sequencer jobs, as DS_SUPPORT mentioned, use Re-set and Run.

If you are using dsjob command, you can run with normal mode and then check the return code and re-set if required using dsjob with RESET mode.

You can find very nice documentation in Online Manuals on dsjob and its options and usage.

Here is an example pseudo code:
Call in Normal mode
dsjob -run -mode NORMAL -wait -jobstatus $DSServer $DSJob
Check for the return code
ReturnCode=$?
If necessary call in RESET mode
dsjob -run -mode RESET -wait -jobstatus $DSServer $DSJob
Hope this well help you.

Kris~
~Kris
Post Reply