Maintenance plan notification email fails

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.

Any ideas?
advlgxAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Eugene ZConnect With a Mentor Commented:
after Database mail setup - > restart sql agent
0
 
advlgxAuthor Commented:
Figured it out.....

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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.