sysdbmaintplan-jobs-transact-sql.md

title	sysdbmaintplan_jobs (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	06/10/2016
ms.prod	sql
ms.prod_service	database-engine
ms.reviewer
ms.technology	system-objects
ms.topic	language-reference
f1_keywords	sysdbmaintplan_jobs sysdbmaintplan_jobs_TSQL
dev_langs	TSQL
helpviewer_keywords	sysdbmaintplan_jobs system table
ms.assetid	bc65cd70-6ef2-4c17-be11-877ecf4efe50
author	stevestein
ms.author	sstein

sysdbmaintplan_jobs (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]

This table is included in [!INCLUDEssNoVersion] to preserve existing information for instances upgraded from a previous version of [!INCLUDEssNoVersion]. [!INCLUDEssNoVersion] does not change the contents of this table. This table is stored in the msdb database.

[!INCLUDEssNoteDepNextAvoid]

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