BookmarkSubscribeRSS Feed
shivrajpawar98
Fluorite | Level 6

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

4 REPLIES 4
SASJedi
SAS Super FREQ

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

 

Check out my Jedi SAS Tricks for SAS Users
Kurt_Bremser
Super User

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.

Sajid01
Meteorite | Level 14

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.

Kurt_Bremser
Super User

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.

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 4 replies
  • 583 views
  • 5 likes
  • 4 in conversation