Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
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.

Community Additions

© 2015 Microsoft