Cluster Failover notification

• sunny.tjk

  SSCertifiable

  Points: 5041

  More actions

  September 28, 2010 at 1:25 pm

  #143480

  When cluster failover happens, is there a way to get notified?

  I'd like to be emailed when it failovers to B node from A node.

  Thanks everyone.

• sunny.tjk

  SSCertifiable

  Points: 5041

  More actions

  September 28, 2010 at 3:13 pm

  #1228677

  Anyone knows how this could be done?

  Thanks.

• WayneS

  SSC Guru

  Points: 95460

  More actions

  September 28, 2010 at 5:32 pm

  #1228721

  Set up a job to run. For the schedule, set it to be when SQL Server Agent starts. For the step, have it email you. I include ServerProperty('ComputerNetBiosName') (or something like that) that returns the physical node that the instance is now running on.

  Wayne
  Microsoft Certified Master: SQL Server 2008
  Author - SQL Server T-SQL Recipes

  ---

  If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

  ---

  Links:
  For better assistance in answering your questions
  Performance Problems
  Common date/time routines
  Understanding and Using APPLY Part 1 & Part 2