catalog.enable_worker_agent (SSISDB Database)

Applies to: SQL Server SSIS Integration Runtime in Azure Data Factory

Enable a Scale Out Worker for Scale Out Master working with this Integration Services catalog.

Syntax

SQL

catalog.enable_worker_agent [ @WorkerAgentId = ] WorkerAgentId

Arguments

[@WorkerAgentId =] WorkerAgentId The worker agent ID of Scale Out Worker. The WorkerAgentId is uniqueidentifier.

Example

This example enables the Scale Out Worker on MachineA.

SQL

SELECT WorkerAgentId, MachineName FROM [catalog].[worker_agents]
GO
-- Result: --
-- WorkerAgentId                           MachineName --
-- 6583054A-E915-4C2A-80E4-C765E79EF61D    MachineA    --

EXEC [catalog].[enable_worker_agent] '6583054A-E915-4C2A-80E4-C765E79EF61D'
GO 

Return Code Value

0 (success)

Result Sets

None

Permissions

This stored procedure requires one of the following permissions:

• Membership to the ssis_admin database role

• Membership to the sysadmin server role

Errors and Warnings

If the worker agent ID is not valid, the stored procedure returns an error.