No mail send with SQL Maintenance Plan

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.

  1. Go to Database mail
  2. Right Click  Click on Configure Database mail.
  3. Click next
  4. Select Manage Profile security
  5. Click Next
  6. Beside Profile name  by default there will be no , change to “Yes”
  7. Finish
Posted in Microsoft, SQL and tagged , , .

2 Comments

Leave a Reply