How do I cancel SSIS jobs in Created Execution status

user_1443098 0
Viewed 422

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.

ssis sql-server
1 Answers

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

enter image description here

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

enter image description here

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
user_51061540
Related