June 28, 2010 at 6:36 am
Hello.
I'd like to build a script to monitor my replication process running on the SQL server.
I have several subscription on a server, and sometimes one of the agent
turns off, it stops.
The problem is that nothing is logged in the SQL logs, so my idea
was to build something to monitor if the processes are running or not.
Any idea how can I build it? What should I use to check this out?
Thanks,
cips
June 28, 2010 at 10:28 pm
Have you tried Replication Monitor?
June 29, 2010 at 1:52 am
Yes, this is useful for on-line checks...I'd like to automate the checks with a script or job....
June 29, 2010 at 2:13 am
well just like any other sql jobs you can set alerts on failure, log them to the sql logs etc. I think your trying to invent something thats already there
June 29, 2010 at 2:58 am
b38911 (6/29/2010)
Yes, this is useful for on-line checks...I'd like to automate the checks with a script or job....
Please check sp_replmonitor* stored procedures.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply