How do I cancel SSIS jobs in Created Execution status

Question

I have two SSIS jobs that are stuck in Created Execution status. They cannot run since the package version has changed (I get Error Msg 27150: The version of the project has changed since the instance of the execution has been created. Create a new execution instance and try again.) I do not want to run this anymore, just delete it.

How can I remove these from the execution log? catalog.stop_operation does not work since there is no active operation for this job.

Note: the job does not appear in Active Operations, since it never started.

Answer 1

SSISDB keeps track of all operations that are currently active/executing. In order to retrieve a list of all active operations, you need to right-click SSISDB and choose Active Operations

You can then click the Stop button located at the bottom right of the window

It’s also possible to do the same process via T-SQL. You can stop a package by calling the stored procedure catalog.stop_operation passing the operation ID as a parameter

Use this query to retrieve all currently running packages in the SSIS. Catalog and their IDs:

SELECT * FROM SSISDB.catalog.executions WHERE end_time IS NULL

The statement below stops the execution of the SSIS package with operation_id=65

EXEC SSISDB.catalog.stop_operation @operation_id =  65