catalog.operations (SSISDB Database)
Displays the details of all operations in the Integration Services catalog.
Column name |
Data type |
Description |
|---|---|---|
operation_id |
bigint |
The unique identifier (ID) of the operation. |
operation_type |
smallint |
The type of operation. |
created_time |
datetimeoffset |
The time when the operation was created. |
object_type |
smallint |
The type of object affected by the operation. The object may be a folder (10), project (20), package (30), environment (40), or instance of execution (50). |
object_id |
bigint |
The ID of the object affected by the operation. |
object_name |
nvarchar(260) |
The name of the object. |
status |
int |
The status of the operation. The possible values are created (1), running (2), canceled (3), failed (4), pending (5), ended unexpectedly (6), succeeded (7), stopping (8), and completed (9). |
start_time |
datetimeoffset |
The time when the operation started. |
end_time |
datetimeoffsset |
The time when the operation ended. |
caller_sid |
varbinary(85) |
The security ID (SID) of the user if Windows Authentication was used to log on. |
caller_name |
nvarchar(128) |
The name of the account that performed the operation. |
process_id |
int |
The process ID of the external process, if applicable. |
stopped_by_sid |
varbinary(85) |
The SID of the user who stopped the operation. |
stopped_by_name |
nvarchar(128) |
The name of the user who stopped the operation. |
server_name |
nvarchar(128) |
The Windows server and instance information for a specified instance of SQL Server. |
machine_name |
nvarchar(128) |
The computer name on which the server instance is running. |
Remarks
This view displays one row for each operation in the Integration Services catalog. It allows the administrator to enumerate all the logical operations that were performed on the server, such as deploying a project or executing a package.
This view displays the following operation types, as listed in the operation_type column:
operation_type Value |
operation_type Description |
object_id Description |
object_name Description |
|---|---|---|---|
1 |
Integration Services initialization |
NULL |
NULL |
2 |
Retention window (SQL Agent job) |
NULL |
NULL |
3 |
MaxProjectVersion (SQL Agent job) |
NULL |
NULL |
101 |
deploy_project (Stored procedure) |
Project ID |
Project name |
106 |
restore_project (Stored procedure) |
Project ID |
Project name |
200 |
create_execution and start_execution (Stored procedures) |
Project ID |
NULL |
202 |
stop_operation (Stored procedure) |
Project ID |
NULL |
300 |
validate_project (Stored procedure) |
Project ID |
Project name |
301 |
validate_package (Stored procedure) |
Project ID |
Package name |
1000 |
configure_catalog (Stored procedure) |
NULL |
NULL |
Permissions
This view requires one of the following permissions:
READ permission on the operation
Membership to the ssis_admin database role
Membership to the sysadmin server role
Note
When you have permission to perform an operation on the server, you also have permission to view information about the operation. Row-level security is enforced; only rows that you have permission to view are displayed.