syscategories (Transact-SQL)

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