Send email if scheduled SAS job errors

[dcooper210]

I have a SAS job that is scheduled to run once a month.  For the past several months it has thrown the following error(s):

ERROR: CLI error trying to establish connection: FATAL 1: database connection refused

ERROR: Error in the LIBNAME statement.

This is because the server changed without my knowledge.  I would like to have these errors sent to me if possible.  I tried this code:

%macro send_mail;

filename mymail email 'dsmith2@somewhere.com' subject='ERROR in job';

%if &syscc>0 %then %do;

data _null_;

%put &syscc;

file mymail;

put 'An ERROR has occurred in the SAS datasets code';

run;

%end;

%else %do;

data _null_;

file mymail;

put 'The SAS datasets job ran to completion';

run;

%end;

%mend;

%send_mail

I put it right after the libname statement.  It sends an email but the message is "The SAS datasets job ran to completion."  I understand I might have to have the program run, save the log, and parse it for the error and then run the program again. 

How does this work with a scheduled job?  Do I need to put it on the scheduler twice?

Thanks,

Debbie

[SASKiwi]

What scheduler are you using? Some schedulers will automatically email you if there is an error. We use this functionality with the LSF scheduler and it means you don't have to code anything.