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;
&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);
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.
&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);
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.