Database send mail

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 [e-mail] -from [e-mail] -subject test -SmtpServer smtp.service.bla.org -port 25

Answer 1

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

Answer 2

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.

Answer 3

I ran this from the server and it sends mail successfully

Send-MailMessage -to [e-mail] -from [e-mail] -subject test -SmtpServer smtp.service.bla.org -port 25

Answer 4

I ran this from the server and it sends mail successfully

Send-MailMessage -to [e-mail] -from [e-mail] -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.

Answer 5

Database log says it was started by me

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

Answer 6

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