syscategories (T-SQL)

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

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.