The Category object represents the attributes of a SQL Server Agent alert, job, or operator category.
SQL Server Agent categories are optional attributes that group alerts, jobs, and operators. With the Category object, you can:
The Name property of a Category object uses the Microsoft® SQL Server™ data type sysname. For each type of SQL Server category, the category name must be unique.
The Type property applies only to categories used for SQL Server Agent jobs. When used with a job, the Type property value can be set. Setting it for SQL Server alert or operator categories results in an error.
To create a SQL Server job category
To create a SQL Server operator category
BeginAlter Method | Refresh Method |
CancelAlter Method | Remove Method (Objects) |
DoAlter Method |
ID Property | Type Property (Category) |
Name Property |