SQL Clone
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: 2522 | Views in the last 30 days: 8
agent jobs    
sql agent