Exceptional handler activity understanding

[vamsi.4a6]

I need to trigger the email notification when any one of the job in sequence is aborted
Design1:

Job1,Job2 and Job3 are connected by conditional-ok trigger

Job1-->Job2-->Job3


Exceptionalhandler-->emailnotificationactivity-->terminator

Understanding:In this design we do not have this combination( OK trigger and an otherwise trigger),so
so code will be inserted by Datastage. Exceptionalhandler will be triggered if any job is aborted

Design2:

Job1,Job2 and Job3 are connected by conditional-ok trigger.
One more output link from each activity will go to sequencer with trigger as otherwise

Job1-->Job2-->Job3---sequencer(all)-->terminator


Exceptionalhandler-->emailnotificationactivity-->terminator

Understanding:In this design we have OK trigger and an otherwise trigger,so
so no code will be inserted by Datastage Exceptionalhandler will not be triggered

Please check whether understanding is correct or not?

[rkashyap]

Your understanding is correct. Exception Handler is triggered by failure of an activity with no explicit failure handling. Please also see this link.

[ssnegi]

Code: Select all

Job1-->Job2-->Job3---sequencer(all)-->terminator 

change this to

Code: Select all

Job1-->Job2-->Job3---sequencer(Any)--> Notification --> terminator 

Since the sequencer is coming from the otherwise link it will be used only if any job finishes with status other than ok.
This will ensure that if any of the jobs fail it will abort the sequence. This also takes care of job that finish with warnings that wont be picked up by the Exception Handler stage.
Then the notification stage will send the email and the job will terminate.

[chulett]

Note that (in spite of what the illustration seems to show) there are links from all three jobs to the Sequencer, hence the need to set it to Any for it to work properly.