Post reply

Need to be alerted when replication failes

  • November 5, 2007 at 3:45 pm

    #180924

    I have replication setup and need to have an email sent to me in case it fails.

    We are not allowed to have SQL Mail installed on the server, so I'm wondering if there is another way to go about monitoring it AND sending me an email.

    thanks

  • November 6, 2007 at 3:42 am

    #748576

    Hi

    Use SMTP mail

    Look for the DLL file ont he internet for SQL

    regards

  • November 7, 2007 at 2:02 am

    #749003

    You could use Gert Drapers extended stored procedure. Works fine!

    http://www.sqldev.net/xp/xpsmtp.htm

  • November 8, 2007 at 6:20 am

    #749423

    Do you have server monitoring software that can monitor the application event log? Another method instead of having SQL send the mail is force an error to the the event log and have your monitoring software pick up the event and cause the alert/email. If you do have something that can monitor the event log for you, then an easy way to get some monitoring quickly is to turn on the alert "Replication: Agent failure" and it will write to the event log. If you have it set to notify someone also and the mail can't be sent, that will write to the event log also.

Viewing 4 posts - 1 through 3 (of 3 total)

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