My SQL Server Agent does not process any of my jobs between 12am and 2am. The job runs for about 30 seconds then it fails. The error is described as follows:
...failed to execute is server package because of error 0x80131904... The timeout period elapsed prior to completion of the operation or the server is not responding...
Some solutions so far mention to increase the time-out from 30, or to speed up the queries in jobs. Thank you in advance for your help.