Sequencer

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
reddy12
Participant
Posts: 99
Joined: Tue Aug 08, 2006 9:34 pm

Sequencer

Post by reddy12 »

I created ine sequencer.That sequence has 12 jobs.

The sequence failed in 8th activity.I fixed the error in that job.after that i restarted that sequence that sequence ran success.that sequence again start from first activity.

my question is how can i restart that sequence from 8th activity(sequence aborted here)?
i mean i got error in 8th activity(that i fixed).After that i ran again but it started from first.

Could anyone please give me idea?
Minhajuddin
Participant
Posts: 467
Joined: Tue Mar 20, 2007 6:36 am
Location: Chennai
Contact:

Post by Minhajuddin »

You can do this by checking the checkbox in Administrator.

The check box is

--> Add Checkpoints so sequence is restartable.


Just check this option.
Minhajuddin

<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

Doing it in the Administrator will set all sequence jobs as 'restartable'. If only the current/few sequences need to be restartable, then you can do it by checking the same option in the job properties of the sequence job.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
reddy12
Participant
Posts: 99
Joined: Tue Aug 08, 2006 9:34 pm

Post by reddy12 »

Thank you both of you guys.I got it.
DSguru2B wrote:Doing it in the Administrator will set all sequence jobs as 'restartable'. If only the current/few sequences need to be restartable, then you can do it by checking the same option in the job properties of the sequence job.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

DSguru2B wrote:Doing it in the Administrator will set all sequence jobs as 'restartable'.
No, it won't. That just sets the default check-boxes for any new jobs created after the change.
-craig

"You can never have too many knives" -- Logan Nine Fingers
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

O ok. O yea, thats right, all present sequence jobs will remain unchanged and new ones will be affected. Thanks for the correction Craig.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Post Reply