Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

sp_delete_category (Transact-SQL)


Removes the specified category of jobs, alerts, or operators from the current server.

Applies to: SQL Server (SQL Server 2008 through current version).

Topic link icon Transact-SQL Syntax Conventions

sp_delete_category [ @class = ] 'class' , [ @name = ] 'name'   

[ @class =] 'class'
The class of the category. class is varchar(8), with no default, and must have one of these values.

JOBDeletes a job category.
ALERTDeletes an alert category.
OPERATORDeletes an operator category.

[ @name =] 'name'
The name of the category to be removed. name is sysname, with no default.

0 (success) or 1 (failure)


sp_delete_category must be run from the msdb database.

Deleting a category recategorizes any jobs, alerts, or operators in that category to the default category for the class.

Only members of the sysadmin fixed server role can run this procedure.

The following example deletes the job category named AdminJobs.

USE msdb ;  
EXEC dbo.sp_delete_category  
    @name = N'AdminJobs',  
    @class = N'JOB' ;  

sp_add_category (Transact-SQL)
sp_help_category (Transact-SQL)
sp_update_category (Transact-SQL)
System Stored Procedures (Transact-SQL)

Community Additions

© 2016 Microsoft