Solved

Maintenance plan notification email fails

Posted on 2007-11-17
2
1,437 Views
Last Modified: 2011-04-14
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?
0
Comment
Question by:advlgx
2 Comments
 

Author Comment

by:advlgx
ID: 20305427
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
 
LVL 42

Accepted Solution

by:
EugeneZ earned 500 total points
ID: 20307839
after Database mail setup - > restart sql agent
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question