Export (0) Print
Expand All

Delete a Job Category

 

This topic describes how to delete a Microsoft SQL Server Agent job category in SQL Server 2014 by using SQL Server Management Studio, Transact-SQL or SQL Server Management Objects.

Job categories help you organize your jobs for easy filtering and grouping. For example, you can organize all your database backup jobs in the Database Maintenance category.

In This Topic

To delete a job category

  1. In Object Explorer, click the plus sign to expand the server where you want to delete a job category.

  2. Click the plus sign to expand SQL Server Agent.

  3. Right-click the Jobs folder and select Manage Job Categories.

  4. In the Manage Job Categoriesserver_name dialog box, select the job category to delete.

  5. Click Delete.

  6. In the Job Categories dialog box, click Yes.

  7. Close the Manage Job Categoriesserver_name dialog box.

Arrow icon used with Back to Top linkUnable to find bookmark 'Top' in topic '{"project_id":"acb1e239-07de-4739-ad90-d32720c7417b","entity_id":"47a7640b-20b3-4639-ab37-b6fc73575e6c","entity_type":"Article","locale":"en-US"}'. Rebuild topic '{"project_id":"acb1e239-07de-4739-ad90-d32720c7417b","entity_id":"47a7640b-20b3-4639-ab37-b6fc73575e6c","entity_type":"Article","locale":"en-US"}' may solve the problem.

To delete a job category

  1. In Object Explorer, connect to an instance of Database Engine.

  2. On the Standard bar, click New Query.

  3. Copy and paste the following example into the query window and click Execute.

    -- deletes the job category named AdminJobs.
    USE msdb ;
    GO 
    EXEC dbo.sp_delete_category
        @name = N'AdminJobs',
        @class = N'JOB' ;
    GO
    

For more information, see sp_delete_category (Transact-SQL).

Arrow icon used with Back to Top linkUnable to find bookmark 'Top' in topic '{"project_id":"acb1e239-07de-4739-ad90-d32720c7417b","entity_id":"47a7640b-20b3-4639-ab37-b6fc73575e6c","entity_type":"Article","locale":"en-US"}'. Rebuild topic '{"project_id":"acb1e239-07de-4739-ad90-d32720c7417b","entity_id":"47a7640b-20b3-4639-ab37-b6fc73575e6c","entity_type":"Article","locale":"en-US"}' may solve the problem.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2015 Microsoft