Maintenance plan notification email fails
Posted on 2007-11-17
I have configured Database Mail on my SQL 2K5 server and created a mail profile. When I execute the TEST, the test email is delivered without problem. However, If I create a maintenance plan, then select email notification to my database mail profile under logging/notification, I get the error in the maintenance plan log:
Could not generate mail report.An exception occurred while executing a Transact-SQL statement or batch.No global profile is configured. Specify a profile name in the @profile_name parameter.