Skip to content

catalog-disable-worker-agent-ssisdb-database.md

Latest commit

 

History

History
54 lines (41 loc) · 1.44 KB

catalog-disable-worker-agent-ssisdb-database.md

File metadata and controls

54 lines (41 loc) · 1.44 KB
title catalog.disable_worker_agent (SSISDB Database)
description catalog.disable_worker_agent (SSISDB Database)
author chugugrace
ms.author chugu
ms.date 12/16/2016
ms.service sql
ms.subservice integration-services
ms.topic concept-article

catalog.disable_worker_agent (SSISDB Database)

[!INCLUDEsqlserver-ssis]

Disable a Scale Out Worker for Scale Out Master working with this [!INCLUDEssISnoversion] catalog.

Syntax

catalog.disable_worker_agent [ @WorkerAgentId = ] WorkerAgentId

Arguments

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

Example

This example disables the Scale Out Worker on MachineA.

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

EXEC [catalog].[disable_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.