Some body have this error : 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. When i execute my maintenance plan.
Resolution
The issue is related to the default email profile, you have to set a default email profile in order for the maintenance plan send the email alert.
Please Follow These steps to Resolve this Problem
1. Go to Database mail
2. Right Click Click on Configure Database mail.
3. wizard will click next
4.select Manage Profile security
5. Click Next
6. Beside Profile name by default there will be no , Please make it yes
7. Finish
