dbo.syscategories (Transact-SQL)


THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Contains the categories used by SQL Server Management Studio to organize jobs, alerts, and operators. This table is stored in the msdb database.

Column nameData typeDescription
category_idintID of the category
category_classintType of item in the category:

 1 = Job

 2 = Alert

 3 = Operator
category_typetinyintType of category:

 1 = Local

 2 = Multiserver

 3 = None
namesysnameName of the category

Community Additions