topic Re: How to pass the job name via email in DI? in SAS Data Management

How to pass the job name via email in DI?

DavidCaliman — Thu, 26 Jun 2014 17:44:04 GMT

I can send email via the Job status handling.

If an error occurs in the job, I need to pass the job name in the message of the email.

How to do it within the handling status of a job?

Searching on google, I see that there is a variable called ETLS_JOBNAME.

And in the code generated by the DI, the following command sends the message of the email:

data _null_;

file sendMail;

dttm = put(datetime(),nldatm.);

put dttm "&message.";

run;

Re: How to pass the job name via email in DI?

MikeFrost — Fri, 18 Jul 2014 18:26:19 GMT

Hi David,

I don't know if you determined a resoluotion for yourself on this question or not. If not, I recommend that you reach out to SAS Technical Support and open a track to have this question addressed.

Regards,

Mike F.

Re: How to pass the job name via email in DI?

Patrick — Sat, 19 Jul 2014 10:38:54 GMT

&ETLS_JOBNAME gets defined as global macro variable. It should therefore be possible to pass this macro variable as message value.

This then generates code as below:

%etls_sendEmail

(address = something,

Message = &ETLS_JOBNAME);