Edit

Share via

sp_delete_category (Transact-SQL)

  • Article

Applies to: SQL Server

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

Transact-SQL syntax conventions

Syntax

syntaxsql 
sp_delete_category
    [ @class = ] 'class'
    , [ @name = ] N'name'
[ ; ]

Arguments

[ @class = ] 'class'

The class of the category. @class is varchar(8), with no default, and must be one of these values.

Value Description
JOB Deletes a job category.
ALERT Deletes an alert category.
OPERATOR Deletes an operator category.

[ @name = ] N'name'

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

Return code values

0 (success) or 1 (failure).

Result set

None.

Remarks

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.

Permissions

You can grant EXECUTE permissions on this procedure, but these permissions might be overridden during a SQL Server upgrade.

Examples

The following example deletes the job category named AdminJobs.

SQL 
USE msdb;
GO

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

Related content