mail notifications failing

Question

mail notifications failing

coenzyme77

SSCommitted

Points: 1669
More actions
September 20, 2007 at 1:39 pm

#118625

Hi everyone,
Database mail is failing to notify operators of job status. I can successfully send a test database e-mail to operators. Any ideas about what
settings I should check? Thanks to everyone for being there to help.
Ed
SQL 9.0.3054

Viewing 15 posts - 1 through 15 (of 31 total)

You must be logged in to reply to this topic. Login to reply

Jason Deyalsingh SSC Enthusiast Points: 186 More actions · Answer 1

you can check the error logs for database mail in 'SQL Server Agent' -> 'Error Logs' . when the log file viewer opens up, select 'database mail'. There should be an error message in there.

coenzyme77 SSCommitted Points: 1669 More actions · Answer 2

Thanks Jason,

When I complete a job with a notification, the SQL Agent Log File Viewer

indicates 'An attempt was made to send and email when no email session

has been established'. Any ideas what could cause a no session condition

for a notification, and yet be able to perform a successful database mail

test?

R.,

Ed

Jason Deyalsingh SSC Enthusiast Points: 186 More actions · Answer 3

you need to make sure the mail profile is enabled in the SQL server agent properties.

right click SQL server agent -> 'properties'

select 'Alert system' then check 'Enable mail profile' under 'mail session' then restart the SQL server agent service.

hope that helps, Ed.

coenzyme77 SSCommitted Points: 1669 More actions · Answer 4

Thank eveyone. I discoverd this last solution on another site just before

returning here. It works.

Omoba SSCommitted Points: 1910 More actions · Answer 5

Ed,

could you please put me through steps you used to configure database mail. i've been struggling with it.

thanks

------------------------------------------------------------------------
All it takes, is a step in the right direction, your feet will manage to find the way. I didn't say it'll be easy!!![font="Comic Sans MS"]:cool:[/font]

Manie Verster SSCertifiable Points: 7152 More actions · Answer 6

bimpe_d (4/25/2008)
Ed,
could you please put me through steps you used to configure database mail. i've been struggling with it.
thanks

bimpe_d,

I see that Ed has not replied to your post yet. If you are still battling go to this website. That is how I set my database mail up and it works together with the solution to this post.

Thanks for the solution! You won't believe how I scanned the internet for a solution to this problem. Sorry, I forgot the name of the person who posted it. ;););););)

:-PManie Verster
Developer
Johannesburg
South Africa

I can do all things through Christ who strengthens me. - Holy Bible
I am a man of fixed and unbending principles, the first of which is to be flexible at all times. - Everett Mckinley Dirkson (Well, I am trying. - Manie Verster)

coenzyme77 SSCommitted Points: 1669 More actions · Answer 7

Maine,

Your post hit my email at 9:12 this morning. Did Maine's response satisfy your question?

R.,

Ed

coenzyme77 SSCommitted Points: 1669 More actions · Answer 8

Oops,

My previous should have gone to you.

"Maine,

Your post hit my email at 9:12 this morning. Did Maine's response satisfy your question?

R.,

Ed "

adams.squared SSCrazy Points: 2675 More actions · Answer 9

I'm having a problem with this. I have my Database Mail setup and I can send test messages. I have made sure that SQL Agent Database Mail is enabled, I have an operator setup under SQL Server Agent called Jobs Failure and made sure it was enabled. I set up a test job that should email me on failures and successes, but I always get this message. " NOTE: Failed to notify 'Jobs Failure' via email."

I'm at a loss.

coenzyme77 SSCommitted Points: 1669 More actions · Answer 10

Adams,

Have you right clicked DataBase Mail \ View Database Mail Log \ Highlight the most recent entry and read the message at the bottom of the log? ... what does it indicate?

R.,

Ed

adams.squared SSCrazy Points: 2675 More actions · Answer 11

The last two messages in the Database Mail Log are:

9/19 8:51

Message

DatabaseMail process is started

9/19 9:01

Message

DatabaseMail process is shutting down

coenzyme77 SSCommitted Points: 1669 More actions · Answer 12

Adams,

If you right click Database Mail, what is the name of the Database Mail_Profile and the To: email account that is successfully receiving the test message?

R.,

Ed

adams.squared SSCrazy Points: 2675 More actions · Answer 13

The profile has the profile I set up, SQLAlerts, but the TO: is blank.

So I go the the profile and check the configuration and there is an SMTP account setup for it with my email address. So I check the Account and it is setup for Database Mail.

Should the TO: field be blank?

Thanks

coenzyme77 SSCommitted Points: 1669 More actions · Answer 14

Adams,

Have you solved the problem in the interim? If not let's back up.You indicated you sent a successful test message. When you right click Database Mail, in the 'Send Test E-Mail from 'server'' dialog box what is the Database Mail Profile name? You must enter a valid SMPT email account in the To: box that will receive the message.

R.,

Ed