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?
Monday, February 20, 2012
Need to trigger a script to run after merge replication finishes
Labels:
connects,
database,
finishes,
merge,
merges,
microsoft,
mysql,
network,
oracle,
replication,
run,
script,
server,
sql,
subscriber,
thepublisher,
thereanything,
trigger
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment