dbo.syscategories (Transact-SQL)

Applies to: SQL Server

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