topic Re: How can I get an email data step to send a notification when the sas program runs from a scheduler? in SAS Programming

How can I get an email data step to send a notification when the sas program runs from a scheduler?

JohnA_Brown — Wed, 03 Sep 2014 14:22:38 GMT

How can I get an email data step to send a notification when the SAS program runs from a scheduler?

I have a data step that sends an email notification to myself when the SAS process is complete.

filename sendmail email ("toaddress@email.com")

subject = "this is a test email";

data _null_;

file sendmail;

/* Body of email */

put ' ';

put 'process completed';

put 'The file is located in the following folder';

put 'folder location';

put ' ';

run;

When I run the process manually when SAS is open, the email notification gets sent. The SAS process, however, is scheduled automatically through windows task scheduler, and although the processs completely runs, i do not get an email notification.

Any ideas on how to solve?

Thank you,

John

Re: How can I get an email data step to send a notification when the sas program runs from a scheduler?

Hima — Wed, 03 Sep 2014 14:33:12 GMT

Can you share the log?

Re: How can I get an email data step to send a notification when the sas program runs from a scheduler?

jakarman — Wed, 03 Sep 2014 14:33:43 GMT

lsf and most other professional schedulers are supporting an email notify as part of their settings.

No need to program sas code for that.

Using the windows scheduler on your desktop is not the best way fort scheduling. As you noticed the mail settings are default connected to outlook.
You must change a lot of settings to an external mailprovider to get around that so it will run as a batch-job.

A batch-job better background-job is a way of running processes without any keyboard / screen interaction.
Did you run your process manually as a batch-job?

Re: How can I get an email data step to send a notification when the sas program runs from a scheduler?

JohnA_Brown — Wed, 03 Sep 2014 14:41:36 GMT

I did not run manually as a batch job that i know if, I am still a fairly new SAS programmer, so not sure how to set this up.

Re: How can I get an email data step to send a notification when the sas program runs from a scheduler?

JohnA_Brown — Wed, 03 Sep 2014 14:44:01 GMT

there are seveal entries int the log, is there anything in particular you want me to send?

Re: How can I get an email data step to send a notification when the sas program runs from a scheduler?

jakarman — Wed, 03 Sep 2014 15:53:35 GMT

For running in batch see: http://support.sas.com/documentation/cdl/en/hostwin/67279/HTML/default/viewer.htm#n0yfzk61sv9f2wn1o2rieqr5jlt6.htm

The crux is using a windows script (.bat .cmd), similar as a scheduler does.

The log should be save so you can see that after it has been run.

For email-usage to an email provider see: http://support.sas.com/documentation/cdl/en/lesysoptsref/67465/HTML/default/viewer.htm#p1v9dr6zep9p9en1prhl6tdy3igx.htm

There are several of those. There must be en emailproivider Exchange server (not your localhost) to serve that.