Michael Brösdorf
michael.broesdorf at web.de
Tue Jun 8 15:55:06 CDT 2004
Thanks Shamil, found the right-click on the SQL Server Agent - I didn't expect it to be there! Searching BOL I only found the topic telling me how to add new categories using DMO... Michael -----Ursprüngliche Nachricht----- Von: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com]Im Auftrag von Shamil Salakhetdinov Gesendet: Dienstag, 8. Juni 2004 20:04 An: dba-sqlserver at databaseadvisors.com Betreff: Re: [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 > _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com