monitoring merge replication - 07-17-2003 , 02:50 AM
We have mssql2000 systems configured for Transactional
replication and would like to automate the monitoring of
successful replication process by sending a page to DBA
support. Which table do i need to monitor or where could i
get the success status of a replication process.
Re: monitoring merge replication - 07-17-2003 , 01:42 PM
As Hilary mentions this can be implemented out of distribution
MSdistribution_history table. [runstats] column = 2 means it successfully
Comments can tell you about specific issues.
MSrepl_error table can help as well.
1 = Start
2 = Succeed
3 = In progress
4 = Idle
5 = Retry
6 = Fail
This posting is provided "AS IS" with no warranties, and confers no rights.
OR if you wish to include a script sample in your post please add "Use of
included script samples are subject to the terms specified at
"Hilary Cotter" <hilaryK (AT) att (DOT) net> wrote
Re: monitoring merge replication - 07-17-2003 , 06:50 PM
If you are using merge replication, you are going to want
to look at the agent status in MSmerge_history, also found
in your distribution database. Run the query below in
your distribution db to get the most recent run status of
your merge agent. Replace the data in angle brackets with
your publication and subscription database names.
declare @mergeid int
declare @status int
select @mergeid = id from MSmerge_agents where publication
= <publication name> and subscriber_db = <subscription db>
select @status = runstatus from MSmerge_history where
agent_id = @mergeid and time = (select Max(time) from
MSmerge_history where agent_id = @mergeid)
Re: monitoring merge replication - 07-19-2003 , 10:04 PM
HI Jc and HC,
Both ur suggestions work.. great thank u