What SSIS jobs are executing and how do I stop one?

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

ssis_executions
USE SSISDB
GO
Exec catalog.stop_operation @operation_id = 33

Leave a Reply

Your email address will not be published. Required fields are marked *