Share via

  • Article

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