sp_delete_category (Transact-SQL)
Applies to:
SQL Server
Removes the specified category of jobs, alerts, or operators from the current server.
Transact-SQL syntax conventions
Syntax
sp_delete_category
[ @class = ] 'class'
, [ @name = ] N'name'
[ ; ]
Arguments
[ @class = ] 'class'
The class of the category. @class is varchar(8), with no default, and must be one of these values.
Value | Description |
---|---|
JOB |
Deletes a job category. |
ALERT |
Deletes an alert category. |
OPERATOR |
Deletes an operator category. |
[ @name = ] N'name'
The name of the category to be removed. @name is sysname, with no default.
Return code values
0
(success) or 1
(failure).
Result set
None.
Remarks
sp_delete_category
must be run from the msdb
database.
Deleting a category recategorizes any jobs, alerts, or operators in that category to the default category for the class.
Permissions
This stored procedure is owned by the db_owner role. You can grant EXECUTE
permissions for any user, but these permissions may be overridden during a SQL Server upgrade.
Examples
The following example deletes the job category named AdminJobs
.
USE msdb;
GO
EXEC dbo.sp_delete_category
@name = N'AdminJobs',
@class = N'JOB';
GO
Related content
Feedback
https://aka.ms/ContentUserFeedback.
În curând: Pe parcursul anului 2024, vom elimina treptat Probleme legate de GitHub ca mecanism de feedback pentru conținut și îl vom înlocui cu un nou sistem de feedback. Pentru mai multe informații, consultați:Trimiteți și vizualizați feedback pentru