We have a SQL agent Job A that runs a SSIS package in Step 1 and then in step 2, triggers another Job B that runs a SSIS package.
The process works fine most days but once or twice a month Job B fails after half a minute or so without starting the SSIS package. The error in the Job History is -Failed to execute IS server package because of error 0x80131904. Description: Execution Timeout Expired The timeout period elapsed prior to completion of the operation or the server is not responding.
This is a standalone job using a service account to run. Both jobs run once a day, As the SSIS package does not start there is no error in the Integration Services Catalogue
Can anyone point me as to where i can start troubleshooting ?