sp_update_category (Transact-SQL)

Applies to: SQL Server

Changes the name of a category.

Syntax

sp_update_category
    [ @class = ] 'class'
    , [ @name = ] N'name'
    , [ @new_name = ] N'new_name'
[ ; ]

The class of the category to update. @class is varchar(8), and can be one of these values.

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

The current name of the category. @name is sysname, with no default.

The new name for the category. @new_name is sysname, with no default.

0 (success) or 1 (failure).

sp_update_category must be run from the msdb database.

To run this stored procedure, users must be granted the sysadmin fixed server role.

The following example renames a job category from AdminJobs to Administrative Jobs.

USE msdb;
GO

EXEC dbo.sp_update_category
  @class = N'JOB',
  @name = N'AdminJobs',
  @new_name = N'Administrative Jobs';
GO

Events

Apr 8, 3 PM - May 28, 7 AM

Sharpen your AI skills and enter the sweepstakes to win a free Certification exam