catalog-add-execution-worker-ssisdb-database.md

title	catalog.add_execution_worker (SSISDB Database)
description	catalog.add_execution_worker (SSISDB Database)
author	chugugrace
ms.author	chugu
ms.date	12/16/2016
ms.service	sql
ms.subservice	integration-services
ms.topic	conceptual
monikerRange	>= sql-server-2017

catalog.add_execution_worker (SSISDB Database)

[!INCLUDEsqlserver-ssis]

[!INCLUDEsqlserver2017]

Adds a [!INCLUDEssISnoversion] 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

Execute packages in Scale Out.