locked
Database send mail RRS feed

  • Question

  •  

    my database send mail does not seem to be sending the email. I setup a profile from an existing instance that works fine.

    I ran this

    EXEC msdb.dbo.sysmail_help_status_sp;

    response: STARTED


    Also I ran a command from the server and that is working fine

    Send-MailMessage -to myemail@bla.org -from _es-no-reply@bla.org -subject test -SmtpServer smtp.service.bla.org -port 25

    Tuesday, February 12, 2019 3:02 PM

Answers

All replies

  • Do not you get the email? Perhaps it arrived to the JUNK folder?

    Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

    MS SQL optimization: MS SQL Development and Optimization
    MS SQL Consulting: Large scale of database and data cleansing
    Remote DBA Services: Improves MS SQL Database Performance
    SQL Server Integration Services: Business Intelligence

    Tuesday, February 12, 2019 3:04 PM
    Answerer
  • and what do the database mail logs say? Right-click Database Mail-->View database mail log. 

    You may have to get with your server team (or whoever manages it) to allow for outbound email from that server where the mail isn't working. 


    Please remember to click "Mark as Answer" if my response answered your question or click "Vote as helpful" if it helped you in any way.

    Tuesday, February 12, 2019 3:25 PM
    Answerer
  • I ran this from the server and it sends mail successfully

    Send-MailMessage -to myemail@bla.org -from _es-no-reply@bla.org -subject test -SmtpServer smtp.service.bla.org -port 25

    Tuesday, February 12, 2019 4:20 PM
  • I ran this from the server and it sends mail successfully

    Send-MailMessage -to myemail@bla.org -from _es-no-reply@bla.org -subject test -SmtpServer smtp.service.bla.org -port 25


    Your answers to the questions we asked above would help understand your issue. 

    Please remember to click "Mark as Answer" if my response answered your question or click "Vote as helpful" if it helped you in any way.

    Tuesday, February 12, 2019 4:22 PM
    Answerer
  • Database log says it was started by me

    I looked at the queue and it says that I have 15 unsent  request

    Tuesday, February 12, 2019 4:26 PM
  • No errors, it should working, perhaps ask  someone who is responsible for the email server to check it out 

    Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

    MS SQL optimization: MS SQL Development and Optimization
    MS SQL Consulting: Large scale of database and data cleansing
    Remote DBA Services: Improves MS SQL Database Performance
    SQL Server Integration Services: Business Intelligence

    Wednesday, February 13, 2019 6:13 AM
    Answerer