SQL-DMO
Job Category Constants (SQLDMO_CATEGORYTYPE_TYPE)
Job category constants classify categories used to organize Microsoft® SQL Server™ Agent jobs.
Job categories are visible in SQL Server Enterprise Manager, and the user can sort jobs listed by category. When an instance of Microsoft SQL Server is designated as a multiserver administration master server, SQL Server Enterprise Manager 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 | Category is used to classify jobs that will execute on an instance of SQL Server on which the job is stored. |
| SQLDMOCategoryType_MultiServerJob | 2 | Category is used to classify jobs that will execute on one or more target servers. |
| SQLDMOCategoryType_None | 3 | Job is not classified using a category. |
| SQLDMOCategoryType_Unknown | 0 | Job category is bad or invalid, or the category object references a classification used for alerts or operators. |