Export (0) Print
Expand All

dbo.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.

Applies to: SQL Server (SQL Server 2008 through current version).

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

Community Additions

ADD
Show:
© 2014 Microsoft