United States (English)

Home Library Learn Samples Downloads Support Community Forums

MSDN Library

Servers and Enterprise Development

SQL Server

SQL Server 2005

Product Documentation

SQL Server 2005 Documentation

SQL Server 2005 Books Online

SQL Server Language Reference

Transact-SQL Reference

System Stored Procedures (Transact-SQL)

SQL Server Agent Stored Procedures (Transact-SQL)

sp_add_alert (Transact-SQL)

sp_add_category (Transact-SQL)

sp_add_job (Transact-SQL)

sp_add_jobschedule (Transact-SQL)

sp_add_jobserver (Transact-SQL)

sp_add_jobstep (Transact-SQL)

sp_add_notification (Transact-SQL)

sp_add_operator (Transact-SQL)

sp_add_proxy (Transact-SQL)

sp_add_schedule (Transact-SQL)

sp_add_targetservergroup (Transact-SQL)

sp_add_targetsvrgrp_member (Transact-SQL)

sp_apply_job_to_targets (Transact-SQL)

sp_attach_schedule (Transact-SQL)

sp_cycle_agent_errorlog (Transact-SQL)

sp_cycle_errorlog (Transact-SQL)

sp_delete_alert (Transact-SQL)

sp_delete_category (Transact-SQL)

sp_delete_job (Transact-SQL)

sp_delete_jobschedule (Transact-SQL)

sp_delete_jobserver (Transact-SQL)

sp_delete_jobstep (Transact-SQL)

sp_delete_jobsteplog (Transact-SQL)

sp_delete_notification (Transact-SQL)

sp_delete_operator (Transact-SQL)

sp_delete_proxy (Transact-SQL)

sp_delete_schedule (Transact-SQL)

sp_delete_targetserver (Transact-SQL)

sp_delete_targetservergroup (Transact-SQL)

sp_delete_targetsvrgrp_member (Transact-SQL)

sp_detach_schedule (Transact-SQL)

sp_enum_login_for_proxy (Transact-SQL)

sp_enum_proxy_for_subsystem (Transact-SQL)

sp_enum_sqlagent_subsystems (Transact-SQL)

sp_grant_proxy_to_subsystem (Transact-SQL)

sp_grant_login_to_proxy (Transact-SQL)

sp_help_alert (Transact-SQL)

sp_help_category (Transact-SQL)

sp_help_downloadlist (Transact-SQL)

sp_help_job (Transact-SQL)

sp_help_jobactivity (Transact-SQL)

sp_help_jobcount (Transact-SQL)

sp_help_jobhistory (Transact-SQL)

sp_help_jobs_in_schedule (Transact-SQL)

sp_help_jobschedule (Transact-SQL)

sp_help_jobserver (Transact-SQL)

sp_help_jobstep (Transact-SQL)

sp_help_jobsteplog (Transact-SQL)

sp_help_notification (Transact-SQL)

sp_help_operator (Transact-SQL)

sp_help_proxy (Transact-SQL)

sp_help_schedule (Transact-SQL)

sp_help_targetserver (Transact-SQL)

sp_help_targetservergroup (Transact-SQL)

sp_manage_jobs_by_login (Transact-SQL)

sp_msx_defect (Transact-SQL)

sp_msx_enlist (Transact-SQL)

sp_msx_get_account (Transact-SQL)

sp_msx_set_account (Transact-SQL)

sp_notify_operator (Transact-SQL)

sp_post_msx_operation (Transact-SQL)

sp_purge_jobhistory (Transact-SQL)

sp_remove_job_from_targets (Transact-SQL)

sp_resync_targetserver (Transact-SQL)

sp_revoke_login_from_proxy (Transact-SQL)

sp_revoke_proxy_from_subsystem (Transact-SQL)

sp_start_job (Transact-SQL)

sp_stop_job (Transact-SQL)

sp_update_alert (Transact-SQL)

sp_update_category (Transact-SQL)

sp_update_job (Transact-SQL)

sp_update_jobschedule (Transact-SQL)

sp_update_jobstep (Transact-SQL)

sp_update_notification (Transact-SQL)

sp_update_operator (Transact-SQL)

sp_update_proxy (Transact-SQL)

sp_update_schedule (Transact-SQL)

sp_update_targetservergroup (Transact-SQL)

Minimize

This topic has not yet been rated - Rate this topic

sp_delete_category (Transact-SQL)

SQL Server 2005

Removes the specified category of jobs, alerts, or operators from the current server.


sp_delete_category [ @class = ] 'class' , [ @name = ] 'name'

[ @class =] 'class'

The class of the category. class is varchar(8), with no default, and must have one of these values.

Value	Description
JOB	Deletes a job category.
ALERT	Deletes an alert category.
OPERATOR	Deletes an operator category.

[ @name =] 'name': The name of the category to be removed. name is sysname, with no default.

Return Code Values

0 (success) or 1 (failure)

None

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.

Only members of the sysadmin fixed server role can run this procedure.

The following example deletes the job category named AdminJobs.

USE msdb ;
GO 

EXEC dbo.sp_delete_category
    @name = N'AdminJobs',
    @class = N'JOB' ;
GO

Reference

sp_add_category (Transact-SQL)
sp_help_category (Transact-SQL)
sp_update_category (Transact-SQL)
System Stored Procedures (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft. All rights reserved.