SQL Server Agent job Categories

Job categories are used to manages the SQL server job agent.

   

 

These values are stored on the system table.

select * from msdb.dbo.syscategories

This contains the categories used by SQL Server Management Studio to organize jobs, alerts, and operators. This table is stored in the msdb database. See below

    

Category class may be

1 - Job
2 - Alert
3 – Operator

Category Type may be

1 - Local
2 - Multiserver
3 - None