Monday, February 13, 2012

aut-restart

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
*** Sent via Developersdex http://www.codecomments.com ***
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
"Darin" <darin_nospam@.nospamever> wrote in message
news:%23KckAxZHIHA.5360@.TK2MSFTNGP03.phx.gbl...
> 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
> *** Sent via Developersdex http://www.codecomments.com ***

No comments:

Post a Comment