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

2 out of 2 rated this helpful - Rate this topic

SQL Server Agent Stored Procedures (Transact-SQL)

SQL Server 2005

Microsoft SQL Server 2005 supports the following system stored procedures that are used by SQL Server Agent to manage scheduled and event-driven activities.

sp_add_alert	sp_help_job
sp_add_category	sp_help_jobactivity
sp_add_job	sp_help_jobcount
sp_add_jobschedule (Transact-SQL)	sp_help_jobhistory
sp_add_jobserver	sp_help_jobs_in_schedule
sp_add_jobstep	sp_help_jobschedule
sp_add_notification	sp_help_jobserver
sp_add_operator	sp_help_jobstep
sp_add_proxy	sp_help_jobsteplog
sp_add_schedule	sp_help_notification
sp_add_targetservergroup	sp_help_operator
sp_add_targetsvrgrp_member	sp_help_proxy
sp_apply_job_to_targets	sp_help_schedule
sp_attach_schedule	sp_help_targetserver
sp_cycle_agent_errorlog	sp_help_targetservergroup
sp_cycle_errorlog	sp_manage_jobs_by_login
sp_delete_alert	sp_msx_defect
sp_delete_category	sp_msx_enlist
sp_delete_job	sp_msx_get_account
sp_delete_jobschedule	sp_msx_set_account
sp_delete_jobserver	sp_notify_operator
sp_delete_jobstep	sp_post_msx_operation
sp_delete_jobsteplog	sp_purge_jobhistory
sp_delete_notification	sp_remove_job_from_targetss
sp_delete_operator	sp_resync_targetserver
sp_delete_proxy	sp_revoke_login_from_proxy
sp_delete_schedule	sp_revoke_proxy_from_subsystem
sp_delete_targetserver	sp_start_job
sp_delete_targetservergroup	sp_stop_job
sp_delete_targetsvrgrp_member	sp_update_alert
sp_detach_schedule	sp_update_category
sp_enum_login_for_proxy	sp_update_job
sp_enum_proxy_for_subsystem	sp_update_jobschedule
sp_enum_sqlagent_subsystems	sp_update_jobstep
sp_grant_proxy_to_subsystem	sp_update_notification
sp_grant_login_to_proxy	sp_update_operator
sp_help_alert	sp_update_proxy
sp_help_category	sp_update_schedule
sp_help_downloadlist	sp_update_targetservergroup

Reference

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.