Was this page helpful?
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

How to: Create a Job Category (SQL Server Management Studio)

This topic describes how to create a Microsoft SQL Server Agent job category. SQL Server Agent provides built-in job categories that you can assign jobs to, or you can create a job category and assign jobs to it.

To create a job category

  1. In Object Explorer, connect to an instance of the SQL Server Database Engine and then expand that instance.

  2. Expand SQL Server Agent, right-click Jobs, and then select Manage Job Categories.

  3. In the Manage Job Categories dialog box, click Add.

  4. Enter a Name for the new job category.

  5. Check the Show all jobsbox. Select one or more jobs for the new category by checking the boxes corresponding to the jobs, and click OK.

    You may have to click Refresh in the Manage Job Categories dialog to see the new job you just created. Click Cancel to return to Object Explorer.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft