数据库维护计划表 (Transact-SQL)Database Maintenance Plan Tables (Transact-SQL)

适用于:Applies to: 是SQL ServerSQL Server(所有支持的版本)yesSQL ServerSQL Server (all supported versions) 适用于:Applies to: 是SQL ServerSQL Server(所有支持的版本)yesSQL ServerSQL Server (all supported versions)

本节的主题说明用于存储数据库维护计划所用信息的系统表。The topics in this section describe the system tables that store information used by database maintenance plans. 这些表保留已从早期版本的 SQL ServerSQL Server 升级的实例的信息。These tables preserve information for instances that are upgraded from an earlier version of SQL ServerSQL Server.

备注

后续版本的 Microsoft SQL Server 将删除该功能。This feature will be removed in a future version of Microsoft SQL Server. 请避免在新的开发工作中使用该功能,并着手修改当前还在使用该功能的应用程序。Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

本节内容In This Section

sysdbmaintplan_databasessysdbmaintplan_databases
每个具有已升级的关联数据库维护计划的数据库在表中占一行。Contains one row for each database that has an associated upgraded database maintenance plan.

sysdbmaintplan_historysysdbmaintplan_history
每个已执行的已升级数据库维护计划操作在表中占一行。Contains one row for each upgraded database maintenance plan action performed.

sysdbmaintplan_jobssysdbmaintplan_jobs
每个已升级的数据库维护计划作业在表中占一行。Contains one row for each upgraded database maintenance plan job.

sysdbmaintplanssysdbmaintplans
每个已升级数据库维护计划在表中占一行。Contains one row for each upgraded database maintenance plan.

另请参阅See Also

维护计划Maintenance Plans