SQL Server Performance

Email Notification upon failover

Discussion in 'SQL Server Clustering' started by jbrochu, Dec 11, 2003.

  1. jbrochu New Member

    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

    http://www.databasejournal.com/features/mssql/article.php/1585201

    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.


    TIA,
    Joe
  2. jbrochu New Member

  3. bradmcgehee New Member

    For this task, we use Event Log Monitor from www.tntsoftware.com. It supports clusters and provides the necessary e-mail notification.

    -----------------------------
    Brad M. McGehee, MVP
    Webmaster
    SQL-Server-Performance.Com
  4. icata New Member

    Have any of you guys used xp_smtp_mail to send mail notifications in the cluster environment?
  5. icata New Member

    Correction : xp_smtp_sendmail

Share This Page