Hi All,
I have four jobs job1(server), job2(parallel), job3(parallel), job4(server).
I have sequencer job which is designed to run all the four jobs.
I have requirement if job4(laoding of data in table) fails then the sequencer should restart and run only job4.
Please guide me how to work on this, as i am new to datastage dont know how to proceed on this...
the sequencer job is desinged as below
jobactivity1----->jobactivity2-->jobactivity3--->jobactivity4--->Stop
Sequencer job if it fails
Moderators: chulett, rschirm, roy
Thanks,chulett wrote:Our last webinar was on this very topic. Search the forum for checkpoints for many discussions on the topic. It is also detailed in the online help for Sequence (no 'r') jobs. ...
Can you please guide with this in more detail...
I am not able to get required solutions...
It will be really grateful and thankfull.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Our last webinar was on this very topic. You can find this at http://www.dsxchange.net/webinar_training.html (or should be able to). If you can't find it. drop a note to editor@dsxchange.com or membershipdirectory@dsxchange.com who jointly look after these things.
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.
Hi,
in administrator
enable "add checkpoints so sequence is restartable on failure" in Project Properties/sequence tab
and enable "Automatically handle activities that fail"
either of the things may help you to solve,
I used to compile the job which is aborted and i had run the sequence without compiling it, it has started from the job that has aborted.
If any solutions available better are most welcome.
in administrator
enable "add checkpoints so sequence is restartable on failure" in Project Properties/sequence tab
and enable "Automatically handle activities that fail"
either of the things may help you to solve,
I used to compile the job which is aborted and i had run the sequence without compiling it, it has started from the job that has aborted.
If any solutions available better are most welcome.
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
Its not either. First one is necessary unless you are not writing your own checkpointed job control.pxraja wrote:Hi,
in administrator
enable "add checkpoints so sequence is restartable on failure" in Project Properties/sequence tab
and enable "Automatically handle activities that fail"
either of the things may help you to solve,
Sequence is restratable only when it aborts. Hence either use "Automatically handle activities that fail" or add terminator to your serqunce to abort it in case of any failure inside the sequence.
One more thing is, this setting will be applicable only for new jobs, not for existing sequences. For them you have to change the job properties of every existing sequence to select this option.
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.![Wink :wink:](./images/smilies/icon_wink.gif)
Genius may have its limitations, but stupidity is not thus handicapped.
![Wink :wink:](./images/smilies/icon_wink.gif)