Sequencer stage substitute

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
basiltarun
Premium Member
Premium Member
Posts: 15
Joined: Tue Sep 09, 2003 10:41 pm

Sequencer stage substitute

Post by basiltarun »

I have 6 job activities (which runs simultaneously)attached to a sequencer with mode as "ANY" ,this sequencer is then connected to a send mail routine activity.In case when any one of the activity fails the sequencer works fine and the failure mail is send,but if another activity fails after the first one it does not sends a mail.Kindly advice.
verify
Premium Member
Premium Member
Posts: 99
Joined: Sun Mar 30, 2008 8:35 am

Post by verify »

Try to implement the job control using the custom trigger, do not rely on "Automatic handle activities" option.
RK Raju
asorrell
Posts: 1707
Joined: Fri Apr 04, 2003 2:00 pm
Location: Colleyville, Texas

Post by asorrell »

Let me ask a question for clarification...

Are you saying that in the second case (two activities fail) no email is sent at all? Or are you saying that when two jobs fail you expected two emails and only got one?

Just to clarify here - the sequencer will (or should) send one email, no matter how many of the previous jobs fail. When it is set to "Any" it is triggered once if any of the links fail. Even if all six of the activities failed, the sequencer will only trigger once.

If you need a separate email sent after each activity failure, then you need to put a conditional trigger off each activity with a notification stage.
Andy Sorrell
Certified DataStage Consultant
IBM Analytics Champion 2009 - 2020
Post Reply