Maintenance Plan Wizard (Select Report Options Page)
Use the Select Report Options page to define a report of the task activity, and to configure the task to notify people when the task is completed. The report contains details of the steps executed by the maintenance plan. This includes any error information.
The mail part of this task uses the sp_notify_operator statement.
Write a report to a text file
Save the report in a file.Folder location
Specify the location of the file that will contain the report.E-mail report
Select the check box to send e-mail when a task fails. To use this task you must have Database Mail enabled and correctly configured with MSDB as a Mail Host Database, and have a Microsoft SQL Server Agent operator with a valid e-mail address.Agent operator
Specify the recipient of the e-mail.Mail profile
Specify the profile that defines the sender of the e-mail.