February 1, 2007 at 10:42 am
I have posted a previous question about using the pre-defined alerts for monitoring a merge replication agent. I have gotten the alerts to work, but they do not work consistantly. Sometimes they will trigger and somtimes they will not. I have looked in BOL, and all it says is how to set alerts with either the stored procedures or Enterprise Manager. Is there any more information on how alerts work, and how to set them up? Also, is there any way to have an alert trigger with no operators defined? I only need the alert to execute a job when it triggers. I really need some in-depth information on alerts, especially the pre-defied replication alerts. Thanks.
February 1, 2007 at 12:58 pm
You can have an alert trigger a job by right clicking on the alert, going to properties, click the response tab, check the execute job box, select the job, and then uncheck any email notifications to operators below.
February 1, 2007 at 1:17 pm
I have done that. The alert will not trigger if I do not have at least one operator defined and set for email. It also skips some times. I set the agent failure alert to execute a job and arranged for the subscriber to be offline when the job ran. It retried 10 times then failed, but the alert did not trigger. Any time I make a change in the properties of the alert, it seems to take a while for the alert to be triggered again.
February 2, 2007 at 12:25 pm
Don't count on the alerts for anything critical. Instead, create a job that checks the status of replication and handles failures accordingly. For my merge replication, I have a job that runs every 10 minutes that restarts any merge agents that have stopped.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply