mail notifications failing

  • 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   

  • 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.

  • 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

  • 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.

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

    returning here. It works.

  • 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]

  • 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)

  • Maine,

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

    R.,

    Ed

  • 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 "

  • 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.

  • 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

  • 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

  • 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

  • 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

  • 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

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

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