Checkpoint run in Sequencer

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

Checkpoint run in Sequencer

Post by saviop »

Hi,

We have jobs 1,2,3,4,5,6 in a Sequence which has restartability. If job 4 aborts, we have to run job 3 onwards. But this requirement is only for job 4 and not for any other job. One way is put both 3 & 4 in a sequence which has no restartability.

Is there any other way?

Thnx,
Savio
tagnihotri
Participant
Posts: 83
Joined: Sat Oct 28, 2006 6:25 am

Re: Checkpoint run in Sequencer

Post by tagnihotri »

Can you elaborate the point "But this requirement is only for job 4 and not for any other job" !
Cheers,
BA
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

I think that would be the best way to go about doing it. Put them in one sequence job and do not make that sequence restartable.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

You can mark job 3 "do not checkpoint run" so that job 3 always runs.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

But this way even if job 5 or job 6 fails, job 3 will run, which the OP doesnt want.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

You obviously have a RMM stage! I can't read that into the requirement.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Re: Checkpoint run in Sequencer

Post by DSguru2B »

saviop wrote:
If job 4 aborts, we have to run job 3 onwards. But this requirement is only for job 4 and not for any other job.
That statement points towards it, doesnt it :roll:
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Post Reply