Transact-SQL Reference
sysdbmaintplan_databases
Contains one row for each database that has an associated maintenance plan. This table is stored in the msdb database.
| Column name | Data type | Description |
|---|---|---|
| plan_id | uniqueidentifier | Maintenance plan ID. |
| database_name | sysname | Name of the database associated with the maintenance plan. |