Changes the name of a category.
sp_update_category [@class =] 'class',
[@name =] 'old_name',
[@new_name =] 'new_name'
Value | Description |
---|---|
ALERT | Updates an alert category. |
JOB | Updates a job category. |
OPERATOR | Updates an operator category. |
0 (success) or 1 (failure)
None
sp_update_category must be run from the msdb database.
Only members of the sysadmin fixed server role or db_owner fixed database role can execute sp_update_category.
This example renames a job category from Table Archixes to Table Archives.
USE msdb
EXEC sp_update_category 'JOB', 'Table Archixes', 'Table Archives'
sp_add_category | sp_help_category |
sp_delete_category | System Stored Procedures |