Usage of sequencers:How to implement "Restartablity&

seemamone · Post by **seemamone** » Thu Feb 26, 2009 4:33 am

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

richdhan · Post by **richdhan** » Thu Feb 26, 2009 4:35 am

Hi,

Make use of the option "Do not checkpoint run" in the job activity S1.

HTH
--Rich

priyadarshikunal · Post by **priyadarshikunal** » Thu Feb 26, 2009 5:52 am

richdhan wrote:Hi,

Make use of the option "Do not checkpoint run" in the job activity S1.

HTH
--Rich

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.

ray.wurlod · Post by **ray.wurlod** » Thu Feb 26, 2009 3:05 pm

Not "sequencer". "Sequence".

A sequencer is a component that you an use in a sequence.

mandyli · Post by **mandyli** » Sun Mar 01, 2009 4:45 pm

yes.

you can able to set this option from DS admin for whole project level or via Job properties for current Job sequence.

Thanks
Man

chulett · Post by **chulett** » Mon Mar 02, 2009 8:05 am

... as long as you understand that 'for whole project level' means 'make it the default in future sequence jobs'. That will not affect any current jobs.