Post reply

Database Mail

  • April 16, 2010 at 8:22 am

    #138487

    Hi, my Database mail account sat up and I can send test sql acount,but I ran my job don't receive email, what do I need to do next?Thank you very much

  • April 16, 2010 at 8:52 am

    #1152898

    You need to enable Mail in SQL ServerAgent Properties -> Alert System

    Then I think you need to restart SQL Server Agent (?)

  • April 16, 2010 at 10:01 am

    #1152979

    it was enabled already

  • April 16, 2010 at 11:52 am

    #1153045

    I re strted the agent and still the same situation, any ideas what else I need to check

  • April 16, 2010 at 1:03 pm

    #1153084

    Any error on database mail log?

    check the setting again whether something got changed.

    Regards
    Durai Nagarajan

  • April 16, 2010 at 2:52 pm

    #1153151

    Did you try the steps suggested in BOL (BooksOnline, the SQL Server help system)? Especially the steps/views described in section "troubleshooting [SQL Server], Database Mail"?


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • April 16, 2010 at 3:12 pm

    #1153165

    How is your notification setup. Is the mail profile assign to a particular user?

  • April 19, 2010 at 7:10 am

    #1153788

    Notification sat up to under:that's how I created under Operators section: contains email account where to send it,which was created as a group account of different users

  • April 19, 2010 at 7:28 am

    #1153811

    What are you using for your smtp relay, maybe its being blocked.

  • April 19, 2010 at 7:41 am

    #1153823

    Post the error message from the table msdb..sysmail_log

  • April 19, 2010 at 7:50 am

    #1153834

    No error messages in sysmail_log

  • April 19, 2010 at 7:57 am

    #1153842

    Verify the following steps from your agent properties:

    1) From Alert System option click the enble profible option. Then select mail system and profile name from which you can send mail successfully.

    Create opeartor and then send mail from agent.

  • April 19, 2010 at 7:59 am

    #1153845

    I did test mail and I got it,so it smptp could be blocked

  • April 19, 2010 at 11:28 pm

    #1154312

    Enable your mail profile as a public profile in your database mail settings.

Viewing 14 posts - 1 through 13 (of 13 total)

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