re-try on replication

Hi!
How to change the number of re-trys in transactional replication
before it times out? Currently (by default) it is set to 10. I would
like to increase it to 30 or 40.
Please advise.
thank you,
T.The retry count is on the advanced tab of the run agent step of the
distribution agent's job.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com|||On Feb 21, 10:15 am, "tolcis" <nytolly...@.gmail.com> wrote:
> Hi!
> How to change the number of re-trys in transactional replication
> before it times out? Currently (by default) it is set to 10. I would
> like to increase it to 30 or 40.
> Please advise.
> thank you,
> T.
One thing I often do is to add a schedule to the replication jobs in
SQL Agent, scheduling them to run every 5 minutes. If one of the
replication agents does time-out and fail, it will restart itself
within 5 minutes.