sp_update_category (T-SQL)

Changes the name of a category.

Syntax

sp_update_category [@class =] 'class',
    [@name =] 'old_name',
    [@new_name =] 'new_name'

Arguments

[@class =] 'class'

Is the class of the category to update. class is varchar(8), with no default, and can be one of these values.

 

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

[@name =] 'old_name'

Is the current name of the category. old_name is sysname, with no default.

[@new_name =] 'new_name'

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

Return Code Values

0 (success) or 1 (failure)

Result Sets

None

Remarks

sp_update_category must be run from the msdb database.

Permissions

Only members of the sysadmin fixed server role or db_owner fixed database role can execute sp_update_category.

Examples

This example renames a job category from Table Archixes to Table Archives.

USE msdb

EXEC sp_update_category 'JOB', 'Table Archixes', 'Table Archives'

See Also