Mairon,
Quanto exatamente voce quer que o email seja enviado?
Tenho essa proc que diz em percentual o total utilizado do disco:
sp_configure 'Ole Automation Procedures',1
GO
RECONFIGURE
GO
DECLARE @hr int
DECLARE @fso int
DECLARE @drive char(1)
DECLARE @odrive int
DECLARE @TotalSize varchar(20) DECLARE @MB Numeric ; SET @MB = 1048576
CREATE TABLE #drives (drive char(1) PRIMARY KEY, FreeSpace int NULL,
TotalSize int NULL) INSERT #drives(drive,FreeSpace) EXEC
master.dbo.xp_fixeddrives EXEC @hr=sp_OACreate
'Scripting.FileSystemObject',@fso OUT IF @hr <> 0 EXEC sp_OAGetErrorInfo
@fso
DECLARE dcur CURSOR LOCAL FAST_FORWARD
FOR SELECT drive from #drives ORDER by drive
OPEN dcur FETCH NEXT FROM dcur INTO @drive
WHILE @@FETCH_STATUS=0
BEGIN
EXEC @hr = sp_OAMethod @fso,'GetDrive', @odrive OUT, @drive
IF @hr <> 0 EXEC sp_OAGetErrorInfo @fso EXEC @hr =
sp_OAGetProperty
@odrive,'TotalSize', @TotalSize OUT IF @hr <> 0 EXEC sp_OAGetErrorInfo
@odrive UPDATE #drives SET TotalSize=@TotalSize/@MB WHERE
drive=@drive FETCH NEXT FROM dcur INTO @drive
End
Close dcur
DEALLOCATE dcur
EXEC @hr=sp_OADestroy @fso IF @hr <> 0 EXEC sp_OAGetErrorInfo @fso
SELECT
(select @@servername) as Server, drive, TotalSize as 'Total(MB)', FreeSpace as 'Free(MB)', 100-(100*FreeSpace)/TotalSize as '% Used'
FROM #drives
ORDER BY drive
DROP TABLE #drives
sp_configure 'Ole Automation Procedures',0
GO
RECONFIGURE
GO
A partir dela basta implementar uma logica de selects + if para envio de email
Fabrizzio A. Caputo
Certificações:
Oracle OCA 11g
MCITP SQL Server 2008 Implementation and Maintenance
MCITP SQL Server 2008 Developer
Blog Pessoal:
www.fabrizziocaputo.wordpress.com
Blog Empresa:
www.tripletech.com.br/blog
Twitter:
@FabrizzioCaputo
Email: fabrizzio.antoniaci@gmail.com
