Database Maintenance Plan Properties (Reporting Page)
When connecting to Microsoft SQL Server 2000 servers, use the Database Maintenance Plan Properties Reporting page to manage the reports of database maintenance plans. New database maintenance plans cannot be created, and some features on this page cannot be modified with SQL Server Management Studio. Use Enterprise Manager instead. Database maintenance plans cannot be created on Microsoft SQL Server 2005. Use maintenance plans instead.
Use this page to save in a file or write to a table a record of the maintenance activities performed by SQL Server.
Write report to a text file in directory
Specify the full path and name of the text file into which the report is to be generated. The report contains details of the steps executed by the maintenance plan, including any error information. The report maintains version information by adding a date to the file name. The date is generated as a suffix to the file name but is added before the extension, in the form _YYYYMMDDHHMM (for example, "DB Maintenance Plan10_199804090838.txt").Click the browse (...) button to change the default directory for the text file. You can select directories only on the instance of SQL Server running the maintenance plan.
- Delete text report files older than
Automatically delete text report files that are older than the specified period. We recommend that you maintain a history of text report files so that you can check executed maintenance tasks as far back in time as you think you may ever need to check, depending on business practices.
- E-mail report to operator
Specify the operator to whom the generated report will be sent through SQL Mail. Click the browse (...) button to specify an existing operator or to create a new one using SQL Server Enterprise Manager.
- Write history to the table msdb.dbo.sysdbmaintplan_history
Write the history report as rows to themsdb.dbo.sysdbmaintplan_historytable on the server where the maintenance plan was executed. The report contains the steps executed by the maintenance plan, including database name, activity, date, result (success or failure), and any error information, with one row for each activity, per database, per execution date.
- View History
Display the Database Maintenance Plan History dialog box, where you can view the history of the database maintenance plan for the local server.
- Limit rows in the table to
Specify the maximum number of rows in the table. These rows represent the history for this plan only. If the number of history rows in the table for this plan exceeds this value, older rows for this plan (representing the earliest recorded history) are deleted. Setting this value can prevent the table from becoming too large and filling the msdb database (unless auto-grow is permitted). The default value is 100.
Write history to the table on server
Write the history report as rows to themsdb.dbo.sysdbmaintplan_historytable on a remote server. Windows Authentication is used to connect to the remote server. The report contains the steps executed by the maintenance plan, including database name, activity, date, result (success or failure), and any error information, with one row for each activity, per database, per execution date.Click the browse (...) button to specify a server from a list of active servers on the network.
- View History
View the history of the database maintenance plan for the remote server.
- Limit rows in the table to
Specify the maximum number of rows in the table representing the history for this plan only. If the number of history rows in the table for this plan exceeds this value, older rows for this plan (representing the earliest recorded history) are deleted. Setting this value can prevent the table from becoming too large and filling the msdb database (unless auto-grow is permitted). The default value is 10,000.