Replication Distribution Agent often dies with the following log entry. At that hour little is ever going on so I am surprised that the error occurs.
Failed Job -> JobName: Instance1-DB1-Instance2-33, StepName: Run agent., Message: Timeout expired. NOTE: The step was retried the requested number of times (10) without succeeding. The step failed..
Any ideas where to start?
Thanks
1. Did you run Distribution Agent in a SQL Agent job? If Yes, can you try to run distrib.exe through command line?
2. Was Distributor/Publisher/Subscriber started when you run the distribution?
3. Do the SQL Agent job owner has the access right to Distributor/Publisher/Subscriber?
Thanks.
This posting is provided AS IS with no warranties, and confers no rights.
|||Yes, this runs as a Job and it runs normally most of the time so I assume the set-up is correct. It seems there is a transient issue that causes the issue. I just can't tell!|||Can you check the cleanup job schedule?
What is the retention setting?
This posting is provided AS IS with no warranties, and confers no rights.
|||From the "timeout" message, it is most likely a network/connectivity issue.
No comments:
Post a Comment