Online Documentation for SQL Administrator for SQL Server

Setting reporting options


Use this section to configure reporting options. Reports are logs that are generated when maintenance plans are executed.

 

Maintenance plans - Maintenance Plan Editor - Setting reporting options

 

 

!CheckBox Write report to a text file

Check this option if you want SQL Server to write a text file report.

 

!RadioButton Create new file

Create a new report file for each execution of the maintenance plan. By default, the report files are written to the computer hosting the instance of SQL Server that contains this maintenance plan, in the folder established as the default log folder during SQL Server setup.

To specify a different folder, enter the full path of the folder in the Folder name field, or click the OpenFile Open file button and navigate to the desired folder.

 

!RadioButton Append to file

Append the report from each plan execution to the file specified in the File name field. You may also specify a file by clicking the OpenFile Open file button and selecting a file from the dialog box.

 

!CheckBox Send report by e-mail

Select this option to transmit the outcome of a maintenance plan execution via e-mail. This option is only available if Database Mail is enabled and properly configured.

 

To operator

Select an operator from the available operators list who will be the recipient of the e-mail. This option is only available if mail is enabled and properly configured.

 

!CheckBox Log to remote server

Check this option to log maintenance plan history to a remote server.

 

Connection

Specify the connection information to use when logging to a remote server.

 

!CheckBox Extended logging

Select this option to include more information in the log. Including this option will increase the size of the stored maintenance plan history.