Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

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

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.