KBA-01025: How do I create a job category for Spitfire in SQL Agent job management?


I want to create and schedule my Spitfire SQL jobs manually, but the wizard does not make it easy to create a category for these jobs.  How do I add one?


In Enterprise Manager:

  1. Expand your server.
  2. Expand Management.
  3. Expand SQL Server Agent.
  4. Select the Jobs collection.
  5. Right click on the Jobs collection.
    1. Select all tasks.
    2. Select Manage Job Categories.
    3. Click the Add button.

Use Query Analyzer

IF (SELECT COUNT(*) FROM msdb.dbo.syscategories WHERE name = N‘Spitfire‘) < 1
EXECUTE msdb.dbo.sp_add_category @name = N‘Spitfire‘

Additional Comments:

We strongly encourage the use of a job category or categories to organize Spitfire Agent Jobs.

KBA-01025; Last updated: October 10, 2016 at 14:00 pm;
Keywords:  SQL server agent configuration