Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Create notifications for failed jobs with one easy script

By Patrick Akhamie,

Just copy and paste the script and get the result. You can tweak it to export the results to csv or xml and email as an attachment if you want but it is designed so anyone can easily understand and use it.

Total article views: 2450 | Views in the last 30 days: 37
 
Tags
job    
notification    
sql agent    
 
Contribute