Email notification for failed jobs in job sequence

xch2005 · Post by **xch2005** » Tue Apr 30, 2013 3:00 pm

Hi,

I have a job sequence where there are 10 jobs running in parallel and all of them need to run even in case some of them fails. How do I send out email notification only for the jobs that failed during execution? Is there a way in Datastage I can acheive this?

Appericiate your time and thanks in advance.

Thanks.

xch2005 · Post by **xch2005** » Tue Apr 30, 2013 3:02 pm

Sorry, forgot to mention that I need to send out only 1 email notifcation with all the failed job names.

Thanks

chulett · Post by **chulett** » Tue Apr 30, 2013 3:09 pm

Off the top of my head, an "out of the box" solution would be to enable the "include status" option in the email. That would list all of the stages in the sequence, noting which ones succeeded and which ones failed.

ray.wurlod · Post by **ray.wurlod** » Tue Apr 30, 2013 3:09 pm

After all the jobs have finished check the $JobStatus activity variable for each and, if any is not DSJS.RUNOK, generate your email.

xch2005 · Post by **xch2005** » Mon May 13, 2013 1:13 pm

Thanks Ray.

Activity variable would determine whether the job failed or not and need to have seperate failure links to send email but that would be for each job.

But, say out of my 10 jobs 3 failed, how do I send out only 1 email notification with these 3 job names that failed.

Thanks

chulett · Post by **chulett** » Mon May 13, 2013 1:25 pm

So... not going to try the 'status' option I posted?

xch2005 · Post by **xch2005** » Mon May 13, 2013 1:39 pm

The option would work for sure but here the requirement is to send out only 1 email notification and that would have the failed job names. If I include the job status in email option that would contain too much information and the users are not really interested for it.

Thanks

ray.wurlod · Post by **ray.wurlod** » Mon May 13, 2013 3:04 pm

If you use Failure triggers, you can bring them together using a Sequencer.

If you don't use Failure triggers, the activity variables for each job activity continue to be available downstream, so you can combine them with a logical expression (for example in a nested condition activity) ahead of generating the email.

chulett · Post by **chulett** » Mon May 13, 2013 4:47 pm

xch2005 wrote:The option would work for sure but here the requirement is to send out only 1 email notification and that would have the failed job names. If I include the job status in email option that would contain too much information and the users are not really interested for it.

Out of curiousity, have you actually tried it and seen what a failure email looks like? I really wouldn't call it "too much information" and I haven't seen anyone who found it any kind of confusing. Saves a lot of shenanigans compared to building "only the failures" in an email and hope you're not dismissing it out of hand without actually ever having seen one.