Answered by:
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 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
-
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
- Proposed as answer by Teige Gao Thursday, February 14, 2019 6:06 AM
- Marked as answer by Ed Price - MSFTMicrosoft employee Thursday, August 8, 2019 9:33 PM
Wednesday, February 13, 2019 6:13 AMAnswerer
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 PMAnswerer -
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 PMAnswerer -
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 PMAnswerer -
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
- Proposed as answer by Teige Gao Thursday, February 14, 2019 6:06 AM
- Marked as answer by Ed Price - MSFTMicrosoft employee Thursday, August 8, 2019 9:33 PM
Wednesday, February 13, 2019 6:13 AMAnswerer