SQL Replication Agent will RETRY for 4085 Years

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. 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
Read More »