catalog.operations(SSISDB 数据库)catalog.operations (SSISDB Database)

适用范围:SQL Server,包括 Linux Azure SQL 数据库yesAzure SQL 数据仓库no并行数据仓库 APPLIES TO: yesSQL Server, including on Linux yesAzure SQL Database yesAzure SQL Data Warehouse noParallel Data Warehouse

适用对象: yesSQL ServeryesAzure SQL 数据库noAzure SQL 数据仓库no并行数据仓库APPLIES TO: yesSQL Server noAzure SQL Database noAzure SQL Data Warehouse noParallel Data Warehouse

显示 Integration ServicesIntegration Services 目录中所有操作的详细信息。Displays the details of all operations in the Integration ServicesIntegration Services catalog.

列名Column name 数据类型Data type 描述Description
operation_idoperation_id bigintbigint 操作的唯一标识符 (ID)。The unique identifier (ID) of the operation.
operation_typeoperation_type smallintsmallint 操作的类型。The type of operation.
created_timecreated_time datetimeoffsetdatetimeoffset 创建操作的时间。The time when the operation was created.
object_typeobject_type smallintsmallint 受操作影响的对象的类型。The type of object affected by the operation. 该对象可能是文件夹 (10)、项目 (20)、包 (30)、环境 (40) 或执行实例 (50)。The object may be a folder (10), project (20), package (30), environment (40), or instance of execution (50).
object_idobject_id bigintbigint 操作影响的对象的 ID。The ID of the object affected by the operation.
object_nameobject_name nvarchar(260) nvarchar(260) 对象的名称。The name of the object.
statusstatus intint 操作的状态。The status of the operation. 可能的值是已创建 (1)、正在运行 (2)、已取消 (3)、失败 (4)、挂起 (5)、意外结束 (6)、已成功 (7)、停止 (8) 和已完成 (9)。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_timestart_time datetimeoffsetdatetimeoffset 开始操作的时间。The time when the operation started.
end_timeend_time datetimeoffssetdatetimeoffsset 操作结束的时间。The time when the operation ended.
caller_sidcaller_sid varbinary(85)varbinary(85) 如果是使用 Windows 身份验证进行登录的,则为用户的安全 ID (SID)。The security ID (SID) of the user if Windows Authentication was used to log on.
caller_namecaller_name nvarchar(128)nvarchar(128) 执行备份操作的帐户的名称。The name of the account that performed the operation.
process_idprocess_id intint 外部进程的进程 ID(如果适用)。The process ID of the external process, if applicable.
stopped_by_sidstopped_by_sid varbinary(85)varbinary(85) 停止操作的用户的 SID。The SID of the user who stopped the operation.
stopped_by_namestopped_by_name nvarchar(128)nvarchar(128) 停止操作的用户名。The name of the user who stopped the operation.
server_nameserver_name nvarchar(128)nvarchar(128) SQL ServerSQL Server 指定实例的 Windows 服务器和实例信息。The Windows server and instance information for a specified instance of SQL ServerSQL Server.
machine_namemachine_name nvarchar(128)nvarchar(128) 运行服务器实例的计算机名称。The computer name on which the server instance is running.

RemarksRemarks

此视图对于 Integration ServicesIntegration Services 目录中的每个操作显示一行。This view displays one row for each operation in the Integration ServicesIntegration 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.

此视图显示以下操作类型,如 operation_type 列中所列出:This view displays the following operation types, as listed in the operation_type column:

operation_typeoperation_type Value operation_type 说明operation_type Description object_id 说明object_id Description object_name 说明object_name Description
1 Integration ServicesIntegration Services 初始化initialization NULLNULL NULLNULL
2 保留窗口Retention window

(SQL 代理作业)(SQL Agent job)
NULLNULL NULLNULL
3 MaxProjectVersionMaxProjectVersion

(SQL 代理作业)(SQL Agent job)
NULLNULL NULLNULL
101 deploy_projectdeploy_project

(存储过程)(Stored procedure)
项目 IDProject ID 项目名称Project name
106 restore_projectrestore_project

(存储过程)(Stored procedure)
项目 IDProject ID 项目名称Project name
200 create_executionstart_executioncreate_execution and start_execution

(存储过程)(Stored procedures)
项目 IDProject ID NULLNULL
202 stop_operationstop_operation

(存储过程)(Stored procedure)
项目 IDProject ID NULLNULL
300 validate_projectvalidate_project

(存储过程)(Stored procedure)
项目 IDProject ID 项目名称Project name
301 validate_packagevalidate_package

(存储过程)(Stored procedure)
项目 IDProject ID 包名称Package name
1000 configure_catalogconfigure_catalog

(存储过程)(Stored procedure)
NULLNULL NULLNULL

权限Permissions

此视图需要下列权限之一:This view requires one of the following permissions:

  • 针对操作的 READ 权限READ permission on the operation

  • ssis_admin 数据库角色的成员资格Membership to the ssis_admin database role

  • sysadmin 服务器角色的成员资格Membership to the sysadmin server role

备注

当您具有在服务器上执行操作的权限时,您还具有查看有关此操作的信息的权限。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.