topic Send E-mail using sas viya code in SAS Programming

Send E-mail using sas viya code

shivrajpawar98 — Fri, 22 Dec 2023 07:03:08 GMT

Hi All,

I want to send alert email through sas viya. whenever the saswork libarary is full then automatically it should send an alert mail

Regards,

Shivraj

Re: Send E-mail using sas viya code

SASJedi — Fri, 22 Dec 2023 13:19:44 GMT

Check out the SAS Communities library article Tip: How to send email using SAS

Re: Send E-mail using sas viya code

Kurt_Bremser — Fri, 22 Dec 2023 13:47:15 GMT

Your SAS might not be able to do anything once WORK is exhausted, so this may not work at all.

Instead use your operating system's tools. Servers have tools to detect such conditions and issue alerts in multiple ways.

Re: Send E-mail using sas viya code

Sajid01 — Tue, 26 Dec 2023 02:28:21 GMT

There are tools at the OS level such as SolarWinds that periodically monitor the work library. Typically, this occurs at 15 minutes interval.

When the free space reduces to a predetermined level (for example 10%), the software sends an alert.
This type of action can be implemented writing a custom script or a SAS program that runs at 15 minutes interval.

Re: Send E-mail using sas viya code

Kurt_Bremser — Tue, 26 Dec 2023 08:45:49 GMT

In UNIX, I'd run the df command, pipe the output into cut to extract the "percentage used" column, after which mail (or mailx) can be used conditionally. All this in a short shell script which can easily be started every minute through cron (such a script only needs milliseconds to run, with minimal CPU use when no mail needs to be sent).

And it is always a VERY GOOD IDEA to run the SAS cleanwork utility periodically to get rid of the remnants of crashed SAS sessions.