Yesterday I setup a Maintenance plan for SQL 2005 with a notification trough mail.
This morning I checked my mailbox, but no mail from the SQL server.
After a quick look in the history from the Maintenance plan, I’ve saw the following 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.
Turns out that I forgot to set the default profile in the database mail.
This is how I resolved the problem.
- Go to Database mail
- Right Click Click on Configure Database mail.
- Click next
- Select Manage Profile security
- Click Next
- Beside Profile name by default there will be no , change to “Yes”