[dba-SQLServer] How to add a new job category

<YourSQLServer> -> Management->SQL Server Agent->
Jobs->RightClick->Manage Job Categories -> Add...

select * from msdb..syscategories -- list all available categories

EXEC sp_help_category @class = 'JOB' -- list job class categories

See BO for more inforation...

HTH,
Shamil

----- Original Message ----- 
From: "Michael Brosdorf" <michael.broesdorf at web.de>
To: <dba-sqlserver at databaseadvisors.com>
Sent: Monday, June 07, 2004 8:14 PM
Subject: [dba-SQLServer] How to add a new job category


> Dear group,
>
> is it possible to add new job categories for the SQL Agent scheduler?
> The '...'-button next to the drop down list only display other jobs in
> the selected category, but does not allow adding new categories.
>
> Michael
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>