Edit

catalog.worker_agents (SSISDB Database)

  • Article

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

Displays the information for the Integration Services Scale Out Worker.

Column name Data type Description
WorkerAgentId uniqueidentifier The worker agent ID of Scale Out Worker.
IsEnabled bit Whether the Scale Out Worker is enabled.
DisplayName nvarchar(256) The display name of Scale Out Worker.
Description nvarchar(256) The description of Scale Out Worker.
MachineName nvarchar(256) The machine name for Scale Out Worker.
Tags nvarchar(max) The tags of Scale Out Worker.
UserAccount nvarchar(256) The user account running the Scale Out Worker service.
LastOnlineTime datetimeoffset(7) The last time that the Scale Out Worker is online.

Remarks

This view displays a row for each Scale Out Worker connecting to the Scale Out Master working with the SSISDB catalog.

Permissions

This view requires one of the following permissions:

  • Membership to the ssis_admin database role

  • Membership to the ssis_cluster_executor database role

  • Membership to the sysadmin server role