Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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)

sp_dba_spacealert_dmo.vbs

By quasar00,

This vbscript is used to alert and email receipients on Filegroup space usage
Ouput:  '% Space Avail. , Space Avail. Filesize, MaxSize, FileName, DBname, FileGroup
The process takes three arguments - SqlserverName ,
Threshold for percentage of available space to check ,
Mininum MaxFileSize to check
Execute the script either from the command line or schedule the script via Sql Server Agent
Command line execution:  cscript.exe sp_dba_spacealert_dmo.vbs sqlservername Threshold MaxfileSize
Sql server agent : cscript sp_dba_spacealert_dmo.vbs  sqlservername Threshold MaxfileSize
The process uses sqlmail which can be installed on any server within your organization

Total article views: 309 | Views in the last 30 days: 1
 
Related Articles
FORUM

Disk Space (Space Available vs. Available Free Space)

Space Available vs. Available Free Space

ARTICLE

Quickly Viewing Available Space

As everyone moves to SQL Server 2005 from SQL Server 2000, there are quite a few pieces of informati...

FORUM

Space available in a DB

Script for checking space of db

FORUM

Sql 2000, Database don't have available space

Sql 2000, Database don't have avialable space

ARTICLE

AlwaysOn Availability Groups in SQL Server 2012

This article discusses and demonstrates AlwaysOn Availability groups in SQL Server 2012, a new featu...

 
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