| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic |
|---|---|---|---|---|---|---|---|
catalog.worker_agents (SSISDB Database) |
catalog.worker_agents (SSISDB Database) |
chugugrace |
chugu |
12/16/2016 |
sql |
integration-services |
conceptual |
[!INCLUDEsqlserver-ssis]
Displays the information for the [!INCLUDEssISnoversion] 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. |
This view displays a row for each Scale Out Worker connecting to the Scale Out Master working with the SSISDB catalog.
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