I have a scenario where I have two job servers (one active and one is passive state), both are configured with similar machine roles, both are in different data centers.

Currently I want to failover my primary job server to the passive one by changing…

Hi,

I am getting below error when 200-300 sql processing jobs are getting executed in parallel. 

[810143] Database error 0: Timeout attempting to open the connection. The time period elapsed prior to attempting to open the connection has been exceeded…