Job abort message as an attachement in email notification

DSRajesh · Post by **DSRajesh** » Sun Oct 20, 2013 8:20 am

Dear All,

I have requirement with when ever job fails in a sequence i need to send the error message with the job failed along with job status in email notification.

I am not sure of to how to get the aborted message and send as an attchement in email

Looking farward for suggestion from any one

Thanks

chulett · Post by **chulett** » Sun Oct 20, 2013 8:48 am

The Notification Activity stage will do that automatically in a Sequence job if you enable the 'Include status' option. Now, it won't be an attachment but you should have the basic information you need with very little effort.

If what you 'need' to pull are the actual error message(s) from the job's log and attach them, you'll need some custom code that leverages the API for the various DSGetLog functions and writes that information to a flat file. The Notification Activity stage can then send that file as an attachment. Or you can script all that from the command line using dsjob and something like sendmail if (for example) you have a job 'wrapper' script that launches all of your jobs.

DSRajesh · Post by **DSRajesh** » Sun Oct 20, 2013 9:02 am

I have checked the option "Include Job Status in Mail" and able to see all job run information including which job got aborted.

But i need to capture the error message with which job has got failed.

Can you please suggest me how can i capture the error message in email notification

DSRajesh · Post by **DSRajesh** » Sun Oct 20, 2013 9:31 am

Chullet

Could you please suggest me some thing here

ray.wurlod · Post by **ray.wurlod** » Sun Oct 20, 2013 11:20 am

The second paragraph of Craig's post tells you what you need to do.

DSRajesh · Post by **DSRajesh** » Mon Oct 21, 2013 4:05 am

Hi

My membership is expired and will renew in a week.

I am unable to see the remaining post send by craig.

Request you to please give the solution for the error message issue.

ArndW · Post by **ArndW** » Mon Oct 21, 2013 4:59 am

It boils down to the answer that there is not built-in way to do this directly in the job, but with sendmail and the DataStage BASIC API it is possible to program this yourself.

DSRajesh · Post by **DSRajesh** » Mon Oct 21, 2013 4:09 pm

Anrnw,

What basic api function will be helpful to extract the error mesage

chulett · Post by **chulett** » Mon Oct 21, 2013 5:46 pm

I'm not Arnd but you can check the help index and look for any that start with 'DSGetLog'.

kduke · Post by **kduke** » Thu Oct 24, 2013 5:09 pm

You could script it with the command line tools. I might of posted a script for this. Need to shell out to run script.