Removes the specified category of jobs, alerts, or operators from the current server.
- [ @class =] 'class'
The class of the category. class is varchar(8), with no default, and must have one of these values.
Deletes a job category.
Deletes an alert category.
Deletes an operator category.
- [ @name =] 'name'
The name of the category to be removed. name is sysname, with no default.
The following example deletes the job category named
USE msdb ; GO EXEC dbo.sp_delete_category @name = N'AdminJobs', @class = N'JOB' ; GO