SQL Server Agent periodically stops executing SSIS jobs

304 views Asked by At

I'm currently having a issue on our SQL Server Agent, I have multiple SSIS packages running from a SSIS Catalogue. These packages are running through without any trouble but at random times during the day they all get stuck in a running status.

I have checked the SSIS catalogue's run history and connections and cant see that there is a request being sent through from SQL Agent to the catalogue to even kick off the job.

Does anyone know what the possible cause of this could be? The only way I have found to fix the issue is by restarting the SQL Agent. It will then start executing the SSIS packages again

0

There are 0 answers