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 |
|
sqlhelp14
Yak Posting Veteran
55 Posts |
Posted - 2008-01-30 : 14:59:57
|
| while executing this sp_send_dbmail i am getting error...means my mail is queued..mail is sent..but not delivered....can u tell me anyone why??EXEC msdb.dbo.sp_send_dbmail @profile_name = 'WebSs', @recipients = 'temp@copm.org', @body = 'The stored procedure finished successfully.', @subject = 'Automated Success Message' can u tell me what's problem? how can i find mail server...MessageThe mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 2 (2008-01-30T14:36:34). Exception Message: Could not connect to mail server. (No such host is known).)thanks |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2008-01-30 : 15:03:17
|
| "Could not connect to mail server. (No such host is known)"Seem like a likely reason.CODO ERGO SUM |
 |
|
|
sqlhelp14
Yak Posting Veteran
55 Posts |
Posted - 2008-01-30 : 15:39:25
|
quote: Originally posted by Michael Valentine Jones "Could not connect to mail server. (No such host is known)"Seem like a likely reason.CODO ERGO SUM
mail server problem solved..now i can receive mails too.. |
 |
|
|
|
|
|