TechNet
Export (0) Print
Expand All

catalog.operations (SSISDB Database)

 

THIS TOPIC APPLIES TO: yesSQL Server (starting with 2012)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Displays the details of all operations in the Integration Services catalog.

Column nameData typeDescription
operation_idbigintThe unique identifier (ID) of the operation.
operation_typesmallintThe type of operation.
created_timedatetimeoffsetThe time when the operation was created.
object_typesmallintThe 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_idbigintThe ID of the object affected by the operation.
object_namenvarchar(260)The name of the object.
statusintThe 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_timedatetimeoffsetThe time when the operation started.
end_timedatetimeoffssetThe time when the operation ended.
caller_sidvarbinary(85)The security ID (SID) of the user if Windows Authentication was used to log on.
caller_namenvarchar(128)The name of the account that performed the operation.
process_idintThe process ID of the external process, if applicable.
stopped_by_sidvarbinary(85)The SID of the user who stopped the operation.
stopped_by_namenvarchar(128)The name of the user who stopped the operation.
server_namenvarchar(128)The Windows server and instance information for a specified instance of SQL Server.
machine_namenvarchar(128)The computer name on which the server instance is running.

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 Valueoperation_type Descriptionobject_id Descriptionobject_name Description
1Integration Services initializationNULLNULL
2Retention window

(SQL Agent job)
NULLNULL
3MaxProjectVersion

(SQL Agent job)
NULLNULL
101deploy_project

(Stored procedure)
Project IDProject name
106restore_project

(Stored procedure)
Project IDProject name
200create_execution and start_execution

(Stored procedures)
Project IDNULL
202stop_operation

(Stored procedure)
Project IDNULL
300validate_project

(Stored procedure)
Project IDProject name
301validate_package

(Stored procedure)
Project IDPackage name
1000configure_catalog

(Stored procedure)
NULLNULL

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

System_CAPS_ICON_note.jpg 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.

Community Additions

ADD
Show:
© 2016 Microsoft