다음을 통해 공유


SQL Server 에이전트 저장 프로시저(Transact-SQL)

Microsoft SQL Server 2005는 SQL Server 에이전트에서 예약된 작업 및 이벤트 기반 작업을 관리하는 데 사용하는 다음과 같은 시스템 저장 프로시저를 지원합니다.

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

참고 항목

참조

시스템 저장 프로시저(Transact-SQL)

도움말 및 정보

SQL Server 2005 지원 받기