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

Alert When Not Enough Free Disk Space

By damcalcan, 2013/05/26

--Implement an Alert Which Trigger when Specified Disks
--free space exceeds a specified alert level

--Steps to implement:
--1) Define a Custom Error Message with messsage text (The ---drive free space is bellow alert level. Details: %s)

--2) Define an Alert linked to CEM defined at step 1

--3) Implement a Job which execute the following step in a recurring way...

--Step
--here you specify  the drives you are intersted in
--and the alert level...The unit measure for alert level is MB
DECLARE @Doc varchar (1000)

SET @Doc = '
    
   
   
    '

EXEC dbo.usp_AlertOnDriveFreeSpaceLevel @Doc

Total article views: 2533 | Views in the last 30 days: 11
 
Related Articles
ARTICLE

SQL Server Alerts

SQL Server Alerts provide a great way for the server to notify a DBA that some event has occurred, u...

FORUM

User-Defined Roles

User-Defined ROLE under the database level

FORUM

STATEMENT LEVEL RECOMPILATION

HELLO TEAM, I need a help on statement level recompile (syntax level) that can implement in sql serv...

ARTICLE

Stairway to T-SQL DML Level 3: Implementing a Relational Model in SQL Server

This level of the stairway details the creation of a relational database, as well as filling in some...

ARTICLE

Stairway to XML: Level 9 - Creating XML-Based Functions

In this Level, we’ll look at how to use XML methods within user-defined functions to return XML frag...

Tags
miscellaneous    
 
Contribute

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones
Editor, SQLServerCentral.com

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones