after job routine for a sequence
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 467
- Joined: Tue Mar 20, 2007 6:36 am
- Location: Chennai
- Contact:
after job routine for a sequence
Hi all,
I have a batch file which archives the source, target and the intermediate files. I want this to be executed in three cases.
1) When the sequence executes successfully
2) When the sequence aborts.
3) When it stops because of warnings.
I searched for ran after job routine option, but was unable to find one. Please help.
Thank you.
I have a batch file which archives the source, target and the intermediate files. I want this to be executed in three cases.
1) When the sequence executes successfully
2) When the sequence aborts.
3) When it stops because of warnings.
I searched for ran after job routine option, but was unable to find one. Please help.
Thank you.
Minhajuddin
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 467
- Joined: Tue Mar 20, 2007 6:36 am
- Location: Chennai
- Contact:
Thanks for the replies...
I can do this -->
1) When the sequence executes successfully --> Add an execute command activity after all the jobs with OK Conditional trigger.
2) When the sequence aborts. Add an execute command activity after all the Exception handler.
3) When it stops because of warnings. --> What do I use for this?
My sequence design is
Thanks for the help...
I can do this -->
1) When the sequence executes successfully --> Add an execute command activity after all the jobs with OK Conditional trigger.
2) When the sequence aborts. Add an execute command activity after all the Exception handler.
3) When it stops because of warnings. --> What do I use for this?
My sequence design is
Code: Select all
Job1
|
|(OK Conditional)
V
Job2
|
|(OK Conditional)
V
...
...
...
Job50
|
|(OK Conditional)
V
ExecuteCommand(Archive the files)
ExceptionHandler-------->ExecuteCommand(Archive the files)---->Terminator
Thanks for the help...
Minhajuddin
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
-
- Charter Member
- Posts: 166
- Joined: Wed Mar 16, 2005 6:52 am
- Location: Mumbai, India
Point 3 will be taken care of along with Point 2.
The exception handler code will be trigerred when DataStage does not know how to proceed in the middle of a sequence map.
E.g.
If Job 1/2 ends in a status other than OK, the exception handler will be triggered and execution will continue after exception handler stage.
The exception handler code will be trigerred when DataStage does not know how to proceed in the middle of a sequence map.
E.g.
Code: Select all
Job1-----> Job2-----> Job3
OK OK
Exception Handler-----><Do Something>
Amey Vaidya<i>
I am rarely happier than when spending an entire day programming my computer to perform automatically a task that it would otherwise take me a good ten seconds to do by hand.</i>
<i>- Douglas Adams</i>
I am rarely happier than when spending an entire day programming my computer to perform automatically a task that it would otherwise take me a good ten seconds to do by hand.</i>
<i>- Douglas Adams</i>
-
- Participant
- Posts: 467
- Joined: Tue Mar 20, 2007 6:36 am
- Location: Chennai
- Contact:
I have just tried it out.....ameyvaidya wrote:Point 3 will be taken care of along with Point 2.
The exception handler code will be trigerred when DataStage does not know how to proceed in the middle of a sequence map.
E.g.
If Job 1/2 ends in a status other than OK, the exception handler will be triggered and execution will continue after exception handler stage.Code: Select all
Job1-----> Job2-----> Job3 OK OK Exception Handler-----><Do Something>
Whenever I have a warning in Job1, the sequence ends with this message.....
Code: Select all
archiving_sequence..JobControl (DSWaitForJob): Job ds_modify0 has finished, status = 2 (Finished with warnings)
Thank you ..
Minhajuddin
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
-
- Participant
- Posts: 467
- Joined: Tue Mar 20, 2007 6:36 am
- Location: Chennai
- Contact:
Hi Craig,
For a sequence with 3 jobs this is easy...
But my sequence has almost 50 jobs......
This approach would be tedious in my scenario...
Thanks for the replies....
For a sequence with 3 jobs this is easy...
But my sequence has almost 50 jobs......
This approach would be tedious in my scenario...
Thanks for the replies....
Minhajuddin
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
-
- Participant
- Posts: 467
- Joined: Tue Mar 20, 2007 6:36 am
- Location: Chennai
- Contact:
If there is no other option, then we have to go with it even if it is "tedious" ![Smile :)](./images/smilies/icon_smile.gif)
Thanks for all your help guys....
![Smile :)](./images/smilies/icon_smile.gif)
Thanks for all your help guys....
Minhajuddin
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: