Share via

  • Article

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.