catalog.stop_operation(SSISDB 数据库)catalog.stop_operation (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 目录中停止执行的验证或实例。Stops a validation or instance of execution in the Integration ServicesIntegration Services catalog.


catalog.stop_operation [ @operation_id = ] operation_id  


[ @operation_id = ] operation_id [ @operation_id = ] operation_id
执行验证或实例的唯一标识符。The unique identifier of the validation or instance of execution. operation_id 为 bigint 。The operation_id is bigint.

返回代码值Return Code Value

0(成功)0 (success)

结果集Result Sets



此存储过程需要下列权限之一:This stored procedure requires one of the following permissions:

  • 针对执行验证或实例的 READ 和 MODIFY 权限READ and MODIFY permissions on the validation or instance of execution

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

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

错误和警告Errors and Warnings

下面的列表描述了一些可能引发错误或警告的情况:The following list describes some conditions that may raise an error or warning:

  • 用户没有相应的权限The user does not have the appropriate permissions

  • 操作标识符无效The operation identifier is not valid

  • 操作已停止The operation has already been stopped


一次只能有一个用户应停止 Integration ServicesIntegration Services 目录的操作。Only one user at a time should stop an operation in Integration ServicesIntegration Services catalog. 如果多个用户试图停止操作,则存储过程在第一次尝试时将返回成功(值 0),但后续尝试将引发错误。If multiple users try to stop the operation, the stored procedure will return success (the value 0) on the first attempt, but subsequent attempts will raise an error.