Export (0) Print
Expand All
Expand Minimize
1 out of 3 rated this helpful - Rate this topic

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.