CODEWITHSUNDEEP
sql-servert-sqlssissql-server-2012sql-server-agent
PURWU
PURWU

Reputation: 427

How To Stop A SSIS Package Step In SQL Server Agent Job

I have a SQL Server Agent job that runs on daily basis and the first step in the job is to execute a SSIS package. For the past a few days the step 1 is being running endlessly. Is there anyway that I can shut down the running step?

enter image description here

Upvotes: 2

Views: 2521

Answers (1)

Wendy
Wendy

Reputation: 660

If you are using Integration Service Catalogs, right click

enter image description here

Open 'Active Operations', there is 'Stop' button.

You can also pull the 'All Execution' Report from Catalog or run query.

-- Status = created (1), running (2), canceled (3), failed (4), pending (5), ended unexpectedly (6), succeeded (7), stopping (8), and completed (9) 
SELECT * FROM SSISDB.[catalog].[executions]

Don't have enough information can help you, what is the 1st step1 message in the job step history? In the job properties, click the step, in the advanced tab, what is the number of Retry attempts? No information how you setup job steps, packages?

Upvotes: 2

Related Questions