Active Operations Dialog Box
Applies To: SQL Server 2016
Use the Active Operations dialog box to view the status of currently running Integration Services operations on the Integration Services server, such as deployment, validation, and package execution. This data is stored in the SSISDB catalog.
What do you want to do?
Open SQL ServerManagement Studio.
Connect Microsoft SQL Server Database Engine
In Object Explorer, expand the Integration Services node, right-click SSISDB, and then click Active Operations.
Specifies the type of operation. The following are the possible values for the Type field and the corresponding values in the operations_type column of the Transact-SQL catalog.operations view.
|Integration Services initialization||1|
|Operations cleanup (SQL Agent job)||2|
|Project versions cleanup (SQL Agent job)||3|
|Create and start package execution||200|
|Stop operation (stopping a validation or execution||202|
Click to stop a currently running operation.