January 7, 2005 at 3:19 am
We have SQL Server 2000 clustered on Windows 2000 Advanced Server.
I would like to be emailed whenever any resource or group fails or changes status. How can I do this?
Thanks in advance,
-Steve
January 7, 2005 at 4:33 am
If you're interested in third-party monitoring tools, try SQLCentric - a comprehensive web-based monitoring and alert system.
In addition to several key features that monitor the health of your SQL Server Infrastructure, it also features cluster failover support, that alerts you anytime the cluster failsover or failsback. It will also display the name of the active node.
Hope this helps!
January 24, 2006 at 8:17 am
I am looking for the samething but I would rather not purchase something to do this. Anyone have any scripts?
January 24, 2006 at 9:11 am
There are free monitoring tools like HP's System Insight Manager which can do this kind of monitoring and more. Is that an option?
Otherwise you could consider building a stored procedure which sends out an email indicating the SQL Server service has started. If you mark that stored procedure to run at startup, it should always fire. However, this would catch any restart, even ones that aren't due to failover.
K. Brian Kelley
@kbriankelley
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply