SQL Server エージェントのストアド プロシージャ (Transact-SQL)SQL Server Agent Stored Procedures (Transact-SQL)

適用対象: yesSQL Server noAzure SQL Database noAzure Synapse Analytics (SQL DW) noParallel Data Warehouse APPLIES TO: yesSQL Server noAzure SQL Database noAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

SQL ServerSQL Server では、スケジュールが設定された作業やイベントにより実行される作業を SQL ServerSQL Server エージェントで管理する場合に、次のシステム ストアド プロシージャを使用できます。supports the following system stored procedures that are used by SQL ServerSQL Server Agent to manage scheduled and event-driven activities.

sp_add_alertsp_add_alert sp_help_jobactivitysp_help_jobactivity
sp_add_categorysp_add_category sp_help_jobcountsp_help_jobcount
sp_add_jobsp_add_job sp_help_jobhistorysp_help_jobhistory
sp_add_jobschedulesp_add_jobschedule sp_help_jobs_in_schedulesp_help_jobs_in_schedule
sp_add_jobserversp_add_jobserver sp_help_jobschedulesp_help_jobschedule
sp_add_jobstepsp_add_jobstep sp_help_jobserversp_help_jobserver
sp_add_notificationsp_add_notification sp_help_jobstepsp_help_jobstep
sp_add_operatorsp_add_operator sp_help_jobsteplogsp_help_jobsteplog
sp_add_schedulesp_add_schedule sp_help_notificationsp_help_notification
sp_add_targetservergroupsp_add_targetservergroup sp_help_operatorsp_help_operator
sp_add_targetsvrgrp_membersp_add_targetsvrgrp_member sp_help_proxysp_help_proxy
sp_apply_job_to_targetssp_apply_job_to_targets sp_help_schedulesp_help_schedule
sp_attach_schedulesp_attach_schedule sp_help_targetserversp_help_targetserver
sp_cycle_agent_errorlogsp_cycle_agent_errorlog sp_help_targetservergroupsp_help_targetservergroup
sp_cycle_errorlogsp_cycle_errorlog sp_manage_jobs_by_loginsp_manage_jobs_by_login
sp_delete_alertsp_delete_alert sp_msx_defectsp_msx_defect
sp_delete_categorysp_delete_category sp_msx_enlistsp_msx_enlist
sp_delete_jobsp_delete_job sp_msx_get_accountsp_msx_get_account
sp_delete_jobschedulesp_delete_jobschedule sp_msx_set_accountsp_msx_set_account
sp_delete_jobserversp_delete_jobserver sp_notify_operatorsp_notify_operator
sp_delete_jobstepsp_delete_jobstep sp_post_msx_operationsp_post_msx_operation
sp_delete_jobsteplogsp_delete_jobsteplog sp_purge_jobhistorysp_purge_jobhistory
sp_delete_notificationsp_delete_notification sp_remove_job_from_targetsssp_remove_job_from_targetss
sp_delete_operatorsp_delete_operator sp_resync_targetserversp_resync_targetserver
sp_delete_proxysp_delete_proxy sp_revoke_login_from_proxysp_revoke_login_from_proxy
sp_delete_schedulesp_delete_schedule sp_revoke_proxy_from_subsystemsp_revoke_proxy_from_subsystem
sp_delete_targetserversp_delete_targetserver sp_start_jobsp_start_job
sp_delete_targetservergroupsp_delete_targetservergroup sp_stop_jobsp_stop_job
sp_delete_targetsvrgrp_membersp_delete_targetsvrgrp_member sp_update_alertsp_update_alert
sp_detach_schedulesp_detach_schedule sp_update_categorysp_update_category
sp_enum_login_for_proxysp_enum_login_for_proxy sp_update_jobsp_update_job
sp_enum_proxy_for_subsystemsp_enum_proxy_for_subsystem sp_update_jobschedulesp_update_jobschedule
sp_enum_sqlagent_subsystemssp_enum_sqlagent_subsystems sp_update_jobstepsp_update_jobstep
sp_grant_proxy_to_subsystemsp_grant_proxy_to_subsystem sp_update_notificationsp_update_notification
sp_grant_login_to_proxysp_grant_login_to_proxy sp_update_operatorsp_update_operator
sp_help_alertsp_help_alert sp_update_proxysp_update_proxy
sp_help_categorysp_help_category sp_update_schedulesp_update_schedule
sp_help_downloadlistsp_help_downloadlist sp_update_targetservergroupsp_update_targetservergroup
sp_help_jobsp_help_job

関連項目See Also

システム ストアド プロシージャ (Transact-SQL)System Stored Procedures (Transact-SQL)