title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic |
---|---|---|---|---|---|---|---|
catalog.stop_operation (SSISDB Database) |
catalog.stop_operation (SSISDB Database) |
chugugrace |
chugu |
03/04/2017 |
sql |
integration-services |
language-reference |
[!INCLUDEsqlserver-ssis]
[!INCLUDE SQL Server]
Stops a validation or instance of execution in the [!INCLUDEssISnoversion] catalog.
catalog.stop_operation [ @operation_id = ] operation_id
[ @operation_id = ] operation_id
The unique identifier of the validation or instance of execution. The operation_id is bigint.
0 (success)
None
This stored procedure requires one of the following permissions:
-
READ and MODIFY permissions on the validation or instance of execution
-
Membership to the ssis_admin database role
-
Membership to the sysadmin server role
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
Only one user at a time should stop an operation in [!INCLUDEssISnoversion] catalog. 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.