jobs.target_groups (Azure Elastic Jobs) (Transact-SQL)
Applies to: Azure SQL Database
Contains all target groups for an elastic job agent in the Azure Elastic Jobs service for Azure SQL Database.
Column name | Data type | Description |
---|---|---|
target_group_name | nvarchar(128) | The name of the target group. |
target_group_id | uniqueidentifier | Unique ID of the target group. |
Permissions
Members of the jobs_reader role can SELECT from this view. For more information, see Elastic jobs in Azure SQL Database.
Caution
You should not update internal catalog views in the job database. Manually changing these catalog views can corrupt the job database and cause failure. These views are for read-only querying only. You can use the stored procedures on your job database.