catalog.add_execution_worker (SSISDB Database)
Applies to:
SQL Server
SSIS Integration Runtime in Azure Data Factory
Applies to:
SQL Server 2017 (14.x) and later
Adds a Integration Services Scale Out Worker to an instance of execution in Scale Out.
Syntax
catalog.add_execution_worker [ @execution_id = ] execution_id, [ @workeragent_id = ] workeragent_id
Arguments
[ @execution_id = ] execution_id
The unique identifier for the instance of execution. The execution_id is bigint.
[@workeragent_id = ] workeragent_id
The worker agent id of a Scale Out Worker. The workeragent_id is uniqueIdentifier.
Return Code Value
0 (success)
Result Sets
None
Permissions
This stored procedure requires one of the following permissions:
READ and MODIFY permissions on the instance of execution
Membership to the ssis_admin database role
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 execution identifier is not valid.
The worker agent id is not valid.
The execution is not in Scale Out.
See Also
Feedback
https://aka.ms/ContentUserFeedback.
Kommer snart: I hele 2024 udfaser vi GitHub-problemer som feedbackmekanisme for indhold og erstatter det med et nyt feedbacksystem. Du kan få flere oplysninger under:Indsend og få vist feedback om