start again a job sequencer only on the jobs in failure
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 43
- Joined: Wed Feb 19, 2003 7:17 am
- Location: France - Paris
- Contact:
start again a job sequencer only on the jobs in failure
Hello,
I read in the post
"difference between Datastage' S release 6x and 7x"
that one could start again a job sequencer only on the jobs in failure. How to make? Is it about a new functionality of V7?
Thank you for your help
Muriel
I read in the post
"difference between Datastage' S release 6x and 7x"
that one could start again a job sequencer only on the jobs in failure. How to make? Is it about a new functionality of V7?
Thank you for your help
Muriel
-
- Participant
- Posts: 43
- Joined: Wed Feb 19, 2003 7:17 am
- Location: France - Paris
- Contact:
It is setup automatically. You have to tell it to not restart a specific job. There is a checkbox for that. In the job activity stgae it says "Do not checkpoint". Do not check this box.
In the job properties there is a checkbox for "Add checkpoints so sequence is restartable on failure". Check this box.
The next checkbox in the job properties is "Automatically handle activities that fail". Check this box.
Next you need an Exception Handler. This stage is not on the normal job stream. We link this to an Email Notofication and then to UtilityAbortToLog.
In the job properties there is a checkbox for "Add checkpoints so sequence is restartable on failure". Check this box.
The next checkbox in the job properties is "Automatically handle activities that fail". Check this box.
Next you need an Exception Handler. This stage is not on the normal job stream. We link this to an Email Notofication and then to UtilityAbortToLog.
Mamu Kim
-
- Participant
- Posts: 43
- Joined: Wed Feb 19, 2003 7:17 am
- Location: France - Paris
- Contact:
Thank you very much.
Is it obligatory to have a stage "Exception Handler" in the Job Sequencer so that that functions??
If so, I did not understand at which place I must positioned.
In entry of each job must it be?
Like the drawing below ?
Muriel
Is it obligatory to have a stage "Exception Handler" in the Job Sequencer so that that functions??
If so, I did not understand at which place I must positioned.
In entry of each job must it be?
Like the drawing below ?
Code: Select all
JobActivity_01------------------------> Sequencer --------------->JobActivity_02
^
|
Exception Handler ----------------------
-
- Participant
- Posts: 43
- Joined: Wed Feb 19, 2003 7:17 am
- Location: France - Paris
- Contact:
-
- Participant
- Posts: 43
- Joined: Wed Feb 19, 2003 7:17 am
- Location: France - Paris
- Contact:
I don't know why, but my AIX DS 7.1 system is acting differently.
I have a job sequence which has two job acitivities, JobA and JobB. These jobs are independent (they each load a different table) and are not connected in any way in the sequence. JobA has two triggers one handling failure, the other everything else ("otherwise" - goes only to a sequence with no further steps). On a failure of JobA, an email is sent and no other steps exist. JobB has only an "OK" trigger which leads to a sequence with no subsequent steps. (This is a test job afterall :D )
When I force JobB to fail (giving it a non-existent database name) and allow JobA to succeed, the sequence simply ends up "Finished", not "Finished/Restartable". The job property checkbox for "Add checkpoints so sequence is restartable on failure" is checked and neither job has the "Do not checkpoint" box checked.
I have tried other setting, with and without automatic error handling, etc, but nothing seems to work. Any thoughts?
Larry
I have a job sequence which has two job acitivities, JobA and JobB. These jobs are independent (they each load a different table) and are not connected in any way in the sequence. JobA has two triggers one handling failure, the other everything else ("otherwise" - goes only to a sequence with no further steps). On a failure of JobA, an email is sent and no other steps exist. JobB has only an "OK" trigger which leads to a sequence with no subsequent steps. (This is a test job afterall :D )
When I force JobB to fail (giving it a non-existent database name) and allow JobA to succeed, the sequence simply ends up "Finished", not "Finished/Restartable". The job property checkbox for "Add checkpoints so sequence is restartable on failure" is checked and neither job has the "Do not checkpoint" box checked.
I have tried other setting, with and without automatic error handling, etc, but nothing seems to work. Any thoughts?
Larry