Hi
I designed a sequencer for five jobs. It is running fine. But I got a problem after 3 jobs 4th job is aborted. I need to restart my sequence for 4 th job only...please some one help me in cheers
thnks
venkat
sequencer problem
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
It's a job sequence you're having a problem with, not a sequencer (which is a component you can used in a job sequence). What version of DataStage are you using - 7.5 or later, or earlier than 7.5? The answer will differ depending on your version number.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 53
- Joined: Fri Apr 18, 2008 8:13 am
- Location: United States
sequencer problem
There is a property at sequence level in the job parameters "ADD CHECKPOINTS SO SEQUENCE IS RESTARTABLE ON FAILURE" which when checked will help you to make the sequence restartable. If this option is not checked in your sequence, please check it and then try running it. If your job gets aborted inbetween, then just make the necessary changes to your job and compile your job alone. No need to compile your sequence again.
Regards
Ajay
Ajay
You can set this option at job level or at the project level.
To set this property at the project level " check the "add checkpoint so sequence is restartable on failure" in sequence tab in data stage adminstrator.
to set at the job level use the job activity stage for individual job.
This feature wasd not available in the earlier release.
After checking in the option, next run will restart the aborted job only.
Thanks,
Birendra
To set this property at the project level " check the "add checkpoint so sequence is restartable on failure" in sequence tab in data stage adminstrator.
to set at the job level use the job activity stage for individual job.
This feature wasd not available in the earlier release.
After checking in the option, next run will restart the aborted job only.
Thanks,
Birendra
Birendra