Email Notification upon failover | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Email Notification upon failover

What is the best and simplest way to send an email upon failover in a two-node active/passive cluster? I have read this link and to me that sounds like overkill for my needs. Any 3rd party software that does this? Why oh why doesn’t Microsoft think of things like this when they make their software? How can someone so rich be so stupid.
Right after I made my post I found this. Thoughts, experiences? SQLCentric v.1.2.3
For this task, we use Event Log Monitor from It supports clusters and provides the necessary e-mail notification. —————————–
Brad M. McGehee, MVP
Have any of you guys used xp_smtp_mail to send mail notifications in the cluster environment?
Correction : xp_smtp_sendmail