syscategories#

Contains the categories used by client tools to organize jobs, alerts, and operators.

Column name

Data type

Description

category_id

int

ID of the category.

category_class

int

Type of item in the category.

category_type

tinyint

Type of category.

name

sysname

Name of the category.