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