Parameter values of a sequence that is restarted

goffinw · Post by **goffinw** » Thu Apr 17, 2008 1:46 am

When the general property 'Add checkpoints...' of a sequence is set, then the sequence is restartable.
When such a sequence aborts then it is in the state 'Aborted/Restartable'.
I noticed that there doesn't exist any action named 'Restart' or such. The only action to restart this sequence is 'Run Now...'. At least in the Director tool.
Uponrestart, if the sequence has Parameters, then the 'Job Run Options' popup window appears.

Question: Do the values of the parameters matter upon restart? I have the impression that they are ignored. Whatever is entered, the parameters used in the restart are the ones that were active when the sequence aborted. Can anyone confirm that?

bkumar103 · Post by **bkumar103** » Thu Apr 17, 2008 3:03 am

The restrartable sequence expects the same parameter list when it was last aborted. If any of the parameter is changed while restart then Data Stage complains about the paramters.

chulett · Post by **chulett** » Thu Apr 17, 2008 6:28 am

In other words, they are not ignored but are used for the run. And the Sequence will log a warning if they are found to be different when restarting from a failure checkpoint. If you reset the job so that it starts over from the beginning, it won't bother with this check.