Hi,
We are using one main Sequencer to call jobs in 3 sequence stages:
S1:Source To Staging
S2:Staging to DataStore
S3:DataStore to Datamart
In case the main sequence aborts in 2nd stageS2, during rerun of the main sequence, the job restarts again from the 1st Stage S1.
Is there any way by which we can make the main sequencer start from 2nd stage itself, in this scenario?
Is there any Project level settings needed to implement this?
thanks in advance.
regards,
Seema
Usage of sequencers:How to implement "Restartablity&
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
Check the box called Add checkpoints so sequence is restartable on failure in job property of sequence. and don't forget to abort the sequence when any of S1, S2 and S3 aborts. The same can be set from administrator but only the new jobs will have the checkpoints by default. in this case also you have to check that box in old sequence you want to be restartable.richdhan wrote:Hi,
Make use of the option "Do not checkpoint run" in the job activity S1.
HTH
--Rich
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.
Genius may have its limitations, but stupidity is not thus handicapped.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: