Have you noticed the SQL Server Agent Job RETRY is set to 2147? Well it is not, the dialog window just cuts off the rest of the digits.![1817.image_5F00_thumb_5F00_7BA1AE8A.png 1817.image_5F00_thumb_5F00_7BA1AE8A.png](http://blogs.msdn.com/cfs-file.ashx/__key/CommunityServer-Blogs-Components-WeblogFiles/00-00-01-34-30-metablogapi/1817.image_5F00_thumb_5F00_7BA1AE8A.png)
Actually the Replication Agent are set by default to retry 2147483647 times, once every minute. That is over 4000 years!2147483647 = 35791394 Hours = 1491308 Days = 4085 Years.How does this impact Replication? Should a Replication Agent fail and the agent be configured for “continuous”, then agent will not report back to SQL Agent Service, but will wait 1 minute, then try again for 4000 years. Any ALTERTS placed with SQL Agent for “job failure” will not get called. Read more: REPLTalk covers Using and Tuning SQL Replication
![1817.image_5F00_thumb_5F00_7BA1AE8A.png 1817.image_5F00_thumb_5F00_7BA1AE8A.png](http://blogs.msdn.com/cfs-file.ashx/__key/CommunityServer-Blogs-Components-WeblogFiles/00-00-01-34-30-metablogapi/1817.image_5F00_thumb_5F00_7BA1AE8A.png)
Actually the Replication Agent are set by default to retry 2147483647 times, once every minute. That is over 4000 years!2147483647 = 35791394 Hours = 1491308 Days = 4085 Years.How does this impact Replication? Should a Replication Agent fail and the agent be configured for “continuous”, then agent will not report back to SQL Agent Service, but will wait 1 minute, then try again for 4000 years. Any ALTERTS placed with SQL Agent for “job failure” will not get called. Read more: REPLTalk covers Using and Tuning SQL Replication
0 comments:
Post a Comment