all groups > sql server replication > november 2007 >
You're in the

sql server replication

group:

aut-restart


aut-restart Darin
11/2/2007 3:03:49 PM
sql server replication:
Windows 2003 w/ SQL Server 2000 merge replication

Is there a way to have the synchrnoziation process restart after a set
amount of time when an error occurs - such as general network failure or
deadlock error?


Darin

Re: aut-restart Hilary Cotter
11/3/2007 9:08:04 AM
I schedule the agent to run every 5 minutes. If this does not work for you,
you can have a 4 job step so if job step 3 fails job step 4 will run. It
will have a waitfor delay for 5 minutes and then loop back to job step 1.

--
RelevantNoise.com - dedicated to mining blogs for business intelligence.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
[quoted text, click to view]

AddThis Social Bookmark Button