Solved

Maintenance plan notification email fails

Posted on 2007-11-17
2
1,426 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

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

708 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now