sql server replication: Transactional Replication Distribution agent -- sql server replication

Transactional Replication Distribution agent

Shahid Saleem
11/2/2007 5:17:48 AM

sql server replication: Dear USers

I have configured a transaction replication and distribution agent is
set to run automatically , Occeasionly network connection is not
available , can you please tell me from where i can set retry intervals
for distribution agent , and if distribution agents fails to connect to
subscriber how many times it retry .....?

Best Regards
Shahid Saleem

Re: Transactional Replication Distribution agent

Hilary Cotter
11/3/2007 9:05:34 AM

There is a parameter on sp_update_jobstep called retry_attempts. You can
also find it by right clicking on the distribution agent, and selecting
agent properties, steps, and double clicking on the run agent step, click on
advanced and you will find them there.

--
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]