Help get this topic noticed by sharing it on Twitter, Facebook, or email.

SF_RefreshAll timeout ?

I'm doing a EXEC SF_RefreshAll 'SALESFORCE', 'Yes' from SSMS and the job ends after 10 mins with a Msg 50000, Level 16, State 1, Procedure SF_RefreshAll, Line 283 [Batch Start Line 0] message. Scheduling this same procedure from SQL Server Agent the job fails consistently after 50 minutes. Are there any timeout settings on the SQL server I should update to get this job to run to completion ? SQL Server 2016
1 person has
this question