Post reply

Unable to get email from Databasemail

  • February 11, 2009 at 10:22 am

    #128722

    Hi,

    I configured the database mail and Iam able to get an email I when send the test mail(Databasemail->Send test mail)

    But Iam Not getting an email when job the succeeds. I did the following

    1. Created a new job.

    2.created the operator ABC

    3.In the Job properties, Notification tab->Email->in the drop down selected the operator name ABC->when job succeds->OK

    but Iam not able to get any email when job succeded

    Please advice where Iam going wrong

  • February 11, 2009 at 10:54 am

    #942368

    Did you configure DB Mail to use an SMTP server when creating the profile?

    Thanks!!

    The_SQL_DBA
    MCTS

    "Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."

  • February 11, 2009 at 11:01 am

    #942374

    Does sending a test email work? If it does did you set the properties of SQL Server Agent Alert System to Enable the mail profile you set up?

    Facts are stubborn things, but statistics are more pliable - Mark Twain
    Carolyn
    SQLServerSpecialists[/url]

  • February 11, 2009 at 11:19 am

    #942389

    Have you checked that the Operator is Enabled (in the Operator properties)?

    Check the Database Mail log to see if anything is causing that error: Database mail -> View Database Mail Log

    Also, as mentioned in the post by dbychen here, make sure the Alert System is enabled..... I had forgotten this as well when implemented a while ago

    _______________________________________________________________________
    For better assistance in answering your questions, click here[/url]

  • February 11, 2009 at 11:35 am

    #942396

    Reproduced this same issue on my own server, searched online and found this blog article.

    Following the instructions there, I could get the alerting email. 🙂

    Here is the trick in that article:

    [font="Comic Sans MS"]In Management Studio, right-click on SQL Server Agent and select "Properties."

    Click "Alert System"

    Unclick "Enable mail profile"

    Click "OK"

    Right-click SQL Server Agent again and select "Properties."

    Click "Alert System"

    Re-click "Enable mail profile"

    Click "OK"

    Restart SQL Server Agent[/font]

  • February 11, 2009 at 11:54 am

    #942408

    Thanks Sunny..

    I followed the steps you suggested and its working perfect!!

    I have one more question.. In Operator properties->Notifications there are 2 radio buttons

    1.Alerts

    2.Jobs

    By default Alterts is selected. Here do I need to change to Jobs?

    I changed to jobs and say ok and if I open Operator properties again its going back to Alerts.

    When should we use these 2 options(In which scenarios)

    Thank You

Viewing 6 posts - 1 through 5 (of 5 total)

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