Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cplusplus
Aged Yak Warrior
567 Posts |
 Posted - 2015-04-17 : 07:41:07
|
| I have database mail configured and the mails were going fine using the mail profile.since last 1 week stopped working from one of the server. in the history log also i am seeing any red error messages, where are the mails going, also checked event viewer still don't see any error codes. the same below test script i used on different servers from there it is working , not on this. Any ideas please. EXEC msdb.dbo.sp_send_dbmail @profile_name = 'MYMailProfileName', @recipients='testmail@gmail.com', @body = 'Hello email from Mydomainhost01', @subject='Ordernet Action Item subject'; |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2015-04-17 : 08:36:31
|
| Check if the database mail is configured correctly. In SSMS object explorer, open Management node, right click database mail, and select send test e-mail and see if that is successful. If not, you should go through the configure database mail and make sure it is configured correctly. Since you have a server on which the mail is working correctly, you can compare the configurations. |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2015-04-19 : 04:42:50
|
| Have you checked the SMPTP server?Are you using a suitable SMPTP address?Jack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
Database mail not working all of a sudden