SQL Server Agent Stored Procedures (Transact-SQL)
TOC
Collapse the table of content
Expand the table of content

SQL Server Agent Stored Procedures (Transact-SQL)

 

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

sp_add_alertsp_help_jobactivity
sp_add_categorysp_help_jobcount
sp_add_jobsp_help_jobhistory
sp_add_jobschedulesp_help_jobs_in_schedule
sp_add_jobserversp_help_jobschedule
sp_add_jobstepsp_help_jobserver
sp_add_notificationsp_help_jobstep
sp_add_operatorsp_help_jobsteplog
sp_add_schedulesp_help_notification
sp_add_targetservergroupsp_help_operator
sp_add_targetsvrgrp_membersp_help_proxy
sp_apply_job_to_targetssp_help_schedule
sp_attach_schedulesp_help_targetserver
sp_cycle_agent_errorlogsp_help_targetservergroup
sp_cycle_errorlogsp_manage_jobs_by_login
sp_delete_alertsp_msx_defect
sp_delete_categorysp_msx_enlist
sp_delete_jobsp_msx_get_account
sp_delete_jobschedulesp_msx_set_account
sp_delete_jobserversp_notify_operator
sp_delete_jobstepsp_post_msx_operation
sp_delete_jobsteplogsp_purge_jobhistory
sp_delete_notificationsp_remove_job_from_targetss
sp_delete_operatorsp_resync_targetserver
sp_delete_proxysp_revoke_login_from_proxy
sp_delete_schedulesp_revoke_proxy_from_subsystem
sp_delete_targetserversp_start_job
sp_delete_targetservergroupsp_stop_job
sp_delete_targetsvrgrp_membersp_update_alert
sp_detach_schedulesp_update_category
sp_enum_login_for_proxysp_update_job
sp_enum_proxy_for_subsystemsp_update_jobschedule
sp_enum_sqlagent_subsystemssp_update_jobstep
sp_grant_proxy_to_subsystemsp_update_notification
sp_grant_login_to_proxysp_update_operator
sp_help_alertsp_update_proxy
sp_help_categorysp_update_schedule
sp_help_downloadlistsp_update_targetservergroup
sp_help_job

System Stored Procedures (Transact-SQL)

Community Additions

ADD
Show:
© 2016 Microsoft