Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts with tag alerts Rss

Search for any content tagged alerts

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)

Add a script

   Items 1 to 4 of 4   
 

Disk space alert per drive

This script validates the sufficient disk space per drive. When you'll reach a minimum on a diskdrive, the script will mail all recipients.  Read more...
By Sven Goossens 2011/12/06 | Source: SQLServerCentral.com | Category: storage management
Rating: |  Discuss |   Briefcase | 3,130 reads

Capture and Alert for Blocked SPIDS with SP_WHO2

This will capture locked/blocked spids and alert with the inputbuffer info as well as the login info. Then email it and record the history of the blocks.  Read more...
By Joshua A. Walker 2013/12/04 | Source: SQLServerCentral.com | Category: sp_who2
Rating: |  Discuss |   Briefcase | 3,270 reads

Create Mirror Alerts for All Mirrored Databases

Creates Mirror State-Change Alerts for ALL mirrored databases on a server - can save hours when setting up multiple mirrored instances  Read more...
By Jordon Pilling 2013/11/29 | Source: SQLServerCentral.com | Category: alerts
Rating: |  Discuss |   Briefcase | 2,775 reads

Runaway Job Management

Be alerted or take custom actions when specified jobs are in the "Running" state for a length of time.  Read more...
By Mark Marinovic 2009/09/25 | Source: SQLServerCentral.com | Category: sql jobs
Rating: (not yet rated) |  Discuss |   Briefcase | 768 reads
   Items 1 to 4 of 4