Export (0) Print
Expand All
Expand Minimize

syscategories

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

Show:
© 2014 Microsoft