Alert or Alarm e-mail when cluster fails over

• skhan-680833

  SSChasing Mays

  Points: 622

  More actions

  March 16, 2010 at 10:59 am

  #386518

  Is there any way to set up and alert using DBmail when the cluster fails over?

  Or any other option to send an alert when the cluster fails over.

  Thanks

  SDKhan

• BuntyBoy

  SSCommitted

  Points: 1876

  More actions

  March 16, 2010 at 11:57 am

  #1134694

  skhan-680833 (3/16/2010)

  ---

  Is there any way to set up and alert using DBmail when the cluster fails over?

  Or any other option to send an alert when the cluster fails over.

  Thanks

  SDKhan

  Hi, you can create a job to send email and schedule it to run when sql server agent restarts. Since, when ever cluster fails over sql server agent gets restarted, so this job will be triggered and you will get notification. You can also prepare a script to check the current active node and put it in the job. Hope this helps. Thanks.

  ===========================================
  Better try and fail than not to try at all...

  Database Best Practices[/url]

  SQL Server Best Practices[/url]