Job category constants classify categories used to organize SQL Server Agent jobs.
Job categories are visible in SQL Server Enterprise Manager, and the user can sort jobs listed by category. When a Microsoft® SQL Server™ installation is designated as a multiserver administration master, 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 servers that are not local.
| Constant | Value | Description |
|---|---|---|
| SQLDMOCategoryType_LocalJob | 1 | Category is used to classify jobs that will execute on the SQL Server installation on which the job is stored |
| SQLDMOCategoryType_ MultiServerJob |
2 | Category is used to classify jobs that will execute on one or more TSX 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 |