Every now and then an SSIS job is still running and you want to kill it to start it over with a fix you made(…in test right, you’d never let this happen in production).
There is a view in the SSISDB that will tell you what is running, and a stored procedure that can stop the running SSIS packages.
USE SSISDB
GO
select * from catalog.executions where end_time is null
USE SSISDB
GO
Exec catalog.stop_operation @operation_id = 33