SQL Server Agent Stored Procedures (Transact-SQL)

THIS TOPIC APPLIES TO: yesSQL Server (starting with 2012)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

SQL Server 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_jobactivity
sp_add_category sp_help_jobcount
sp_add_job sp_help_jobhistory
sp_add_jobschedule sp_help_jobs_in_schedule
sp_add_jobserver sp_help_jobschedule
sp_add_jobstep sp_help_jobserver
sp_add_notification sp_help_jobstep
sp_add_operator 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
sp_help_job

See Also

System Stored Procedures (Transact-SQL)