Monday, February 20, 2012

Need to trigger a script to run after merge replication finishes

After a subscriber connects to the network and merges the data with the
publisher I’m looking for a way to trigger a script to run. Is there
anything built into SQL Server to do such a thing?
Normally this is done with a final job step. Right click on your merge
agent, select agent properties, click on steps, and add a 4th job. Have the
3rd steps On Failure action be quit with failure, and on Success action be
go to next step.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Pauly C" <paulysc@.optonline.net> wrote in message
news:8E4CE71B-F2D0-432E-8FD5-887E7805174B@.microsoft.com...
> After a subscriber connects to the network and merges the data with the
> publisher I'm looking for a way to trigger a script to run. Is there
> anything built into SQL Server to do such a thing?

No comments:

Post a Comment