Adds the specified category of jobs, alerts, or operators to the server.
Transact-SQL Syntax Conventions
sp_add_category [ [ @class = ] 'class', ] [ [ @type = ] 'type', ] { [ @name = ] 'name' }
The class of the category to be added. class is varchar(8) with a default value of JOB, and can be one of these values.
Value
Description
JOB
Adds a job category.
ALERT
Adds an alert category.
OPERATOR
Adds an operator category.
The type of category to be added. type is varchar(12), with a default value of LOCAL, and can be one of these values.
LOCAL
A local job category.
MULTI-SERVER
A multiserver job category.
NONE
A category for a class other than JOB.
The name of the category to be added. The name must be unique within the specified class. name is sysname, with no default.
0 (success) or 1 (failure)
None
sp_add_category must be run from the msdb database.
Only members of the sysadmin fixed server role can execute sp_add_category.
The following example creates a local job category named AdminJobs.
USE msdb ; GO EXEC dbo.sp_add_category @class=N'JOB', @type=N'LOCAL', @name=N'AdminJobs' ; GO
.png)
