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 name Data type Description
category_id int ID of the category
category_class int Type of item in the category:

1 = Job

2 = Alert

3 = Operator
category_type tinyint Type of category:

1 = Local

2 = Multiserver

3 = None
name sysname Name of the category