已不再支援此瀏覽器。
請升級至 Microsoft Edge,以利用最新功能、安全性更新和技術支援。
SQL Server 支援下列 SQL Server Agent 用來管理已排程和事件驅動活動的系統預存程序。
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
系統預存程序 (Transact-SQL)