Regarding sequence restarting
Posted: Tue Apr 04, 2006 1:11 am
Hi,
We are using DataStage 7.5.1
1. Can we write a routine which compiles all the jobs present in a project. If yes, then please specify.
2. Consider the following scenario.
a. We have a Master sequnce which contains a group of base sequnces which runs one after the other if they are successful.
b. A base sequence contains a collection of jobs.
c. I have checked the options Add checkpoints so sequnce is..... and "Automatically handle activtities that fail." for all base level and master.
d. If one of the jobs in the base level sequences is aborted then the base level sequence and master sequence is also aborted. (This is what I expected)
e. After correcting the failed job, if I run the Master sequence it restarts but it resetting the aborted base level sequence. But my requirement is that base level sequence should also start from the failed job.
We are using DataStage 7.5.1
1. Can we write a routine which compiles all the jobs present in a project. If yes, then please specify.
2. Consider the following scenario.
a. We have a Master sequnce which contains a group of base sequnces which runs one after the other if they are successful.
b. A base sequence contains a collection of jobs.
c. I have checked the options Add checkpoints so sequnce is..... and "Automatically handle activtities that fail." for all base level and master.
d. If one of the jobs in the base level sequences is aborted then the base level sequence and master sequence is also aborted. (This is what I expected)
e. After correcting the failed job, if I run the Master sequence it restarts but it resetting the aborted base level sequence. But my requirement is that base level sequence should also start from the failed job.