Post reply

Alert or Alarm e-mail when cluster fails over

  • 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

  • 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]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply