Job Category Constants (SQLDMO_CATEGORYTYPE_TYPE)
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
Job category constants classify categories used to organize SQL Server Agent jobs.
Job categories are visible in SQL Server Management Studio and the user can sort jobs listed by category. If an instance of Microsoft SQL Server is designated as a multiserver administration master server, SQL Server Management Studio lists jobs using two folders. One folder lists jobs with categories whose type indicates a local target. The second folder lists jobs with categories whose type indicates that jobs of that category target one or more remote servers.
Constant |
Value |
Description |
|---|---|---|
SQLDMOCategoryType_LocalJob |
1 |
This category is used to classify jobs that run on an instance of Microsoft SQL Server on which the job is stored. |
SQLDMOCategoryType_MultiServerJob |
2 |
Thes category is used to classify jobs that run on one or more target servers. |
SQLDMOCategoryType_None |
3 |
The job is not classified using a category. |
SQLDMOCategoryType_Unknown |
0 |
The job category is not valid, or the category object references a classification used for alerts or operators. |