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
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Admin alerts

Author  Topic 

sqlpal2007
Posting Yak Master

200 Posts

Posted - 2008-09-04 : 11:36:06
Hello All,

I need help to write sql programs to email or write to a table if
1. Tables from all major databases need defrag or reindex.
2. Log file out grown
3. Disk/drive out of space
4. sql jobs failed

Can any one tell me how to write queries to achieve these outcomes? Based on these alerts DBA can perform needed tasks.

Thank you in advance,
-P
   

- Advertisement -