sys.sp_add_category
general #stored-procedure
Description
Adds the specified category of jobs, alerts, or operators to the server. For alternative method, The class of the category to be added.
Syntax
sp_add_category
[ [ @class = ]
'class'
]
[ , [ @type = ]
'type'
]
[ , [ @name = ]
'name'
]
[ ; ]Examples
Example 1
AdminJobs
Example 2
USE msdb;
GO
EXECUTE dbo.sp_add_category
@
class
= N
'JOB'
,
@
type
= N
'LOCAL'
,
@
name
= N
'AdminJobs'
;
GO