syscategories System Table - SQL Server 2000
Contains the categories used by SQL Server Enterprise Manager 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