February 9, 2013 at 11:37 pm
In my environment, there is a merge replication configured . In one database three merge replications is configured.
The database has xml datatype, hence we split into 3 merge replications.
The merge replication is not getting completed by evening.
I got the requirement that , I need to notify the team at subscriber location by mail that merge replication is complete and there is no pending transactions .
Is there any script with which I can know merge replication is complete.
I am thinking of creating a sql job which will send notifications when the replication is complete.
To start with, I thought of using memerge_sessions and msmerge_genhistory with the runstatus column.
Can someone help me with the scripts if you have.
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply