sp_add_maintenance_plan_job

Transact-SQL Reference

Transact-SQL Reference

sp_add_maintenance_plan_job

Associates a maintenance plan with an existing job.

Syntax

sp_add_maintenance_plan_job [ @plan_id = ] 'plan_id'
, [ @job_id = ] 'job_id'

Arguments

[@plan_id =] 'plan_id'

Specifies the ID of the maintenance plan. plan_id is uniqueidentifier, and must be a valid ID.

[@job_id =] 'job_id'

Specifies the ID of the job to be associated with the maintenance plan. job_id is uniqueidentifier, and must be a valid ID. To create a job or jobs, execute sp_add_job, or use SQL Server Enterprise Manager.

Return Code Values

0 (success) or 1 (failure)

Remarks

sp_add_maintenance_plan_job must be run from the msdb database.

Permissions

Only members of the sysadmin fixed server role can execute sp_add_maintenance_plan_job.

Examples

This example adds the job "B8FCECB1-E22C-11D2-AA64-00C04F688EAE" to the maintenance plan created with sp_add_maintenance_plan_job.

EXECUTE   sp_add_maintenance_plan_job N'FAD6F2AB-3571-11D3-9D4A-00C04FB925FC', N'B8FCECB1-E22C-11D2-AA64-00C04F688EAE'