November 2, 2006 at 1:31 pm
Are there sps to start and stop merge agents?
I know how to configure a stopped merge agent to start itself back up again, but if it's successfully running and I want to make a call to it to stop, how would that be done?
November 3, 2006 at 11:47 am
no stored procedure for stopping and starting the merge agent according to my review of BOL. There is a merge agent utility with a ton of optional parameters... i.e., there's a -ForceConvergenceLevel (0|1|2) (Publisher|Subscriber|Both).
Not really sure what you are trying to do... but, you might look here... search BOL for "merge agent"...
Thank-you,
David Russell
Any Cloud, Any Database, Oracle since 1982
November 3, 2006 at 12:22 pm
I have a fully replicating set of servers, and I'm replicating the last 90 days of data to a tertiary server with merge replication. It's merge rather than snapshot, so if the main system is lost inputs can come into the 90d server and replicate back when the system is back. In order to keep only 90 days, and not keep adding on top of the initial transfer, I have a subscription filter in place, which requires the agent to be reinitialized when the filter value changes. But it doesn't see the new value unless the agent stops. So I'd like to schedule the agent to stop once a week, for example, reinitialize, then pick up with the new data and lose the old.
I can set a reinitialization any time, but unless another factor comes into the picture, my merge agent doesn't stop.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply