sysdbmaintplan_jobs

Transact-SQL Reference

Transact-SQL Reference

sysdbmaintplan_jobs

Contains one row for each maintenance plan job. This table is stored in the msdb database.

Column name Data type Description
plan_id uniqueidentifier Maintenance plan ID.
job_id uniqueidentifier ID of a job associated with the maintenance plan.