'Random failure of SQL Agent Job WITHOUT executing SSIS package

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 -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 ?

ssissql-server-2012


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions