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.
Binnenkort: Gedurende 2024 worden GitHub Issues uitgefaseerd als het feedbackmechanisme voor inhoud. Dit wordt vervangen door een nieuw feedbacksysteem. Ga voor meer informatie naar:Feedback verzenden en bekijken voor