Post reply

SQL Email to Report Merge Agent Failure

  • February 13, 2006 at 11:40 pm

    #93382

    I would like to be proactive and detect replication merge agent failure before the users complain about their data being out of date.

    Please help with a procedure to set up SQL email and how to set up an email alert to be sent when the merge agent fails.

    We are using SQL 2000 and the merge agent is set to run continuously.

  • February 15, 2006 at 6:34 am

    #621000

    1. Set up a job to run every xx amount of time to check and see if the merge agent job is running.  If it's not, then send the email and restart the job.

    2.  If you just want email notification then modify the MERGE AGENT JOB to notify OPERATOR when the job fails.

  • February 15, 2006 at 6:52 am

    #621010

    Thanks, I will try that.

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

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