Jobs - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Jobs

Author

Topic

Frozen_123
Starting Member

33 Posts

Posted - 2007-11-09 : 18:27:43

Hi All,

I want to create a job which will basically fetch the information from the system. I mean job will fetch the following information about disk available in the system.

1) Drive
2) Total Size
3) Available Space
4) %free space

Suppose I have 3 drives d,h,i
The information should look like this

Drive Totalsize Available Space %free space
H 2 Gb 1 GB 50%

Can anyone please help me.

Regards,
Frozen

nathans
Aged Yak Warrior

938 Posts

Posted - 2007-11-09 : 19:44:02

Have you looked into:

exec master.dbo.xp_fixeddrives

There are many examples on the Net describing how to put the resultset of this into an alert email.

Nathan Skerl