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.
Specify the location of the file that will contain the 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.
Specify the recipient of the e-mail.
Specify the profile that defines the sender of the e-mail.