SQL 2005, Database Mail - SQL Server Forums

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.

All Forums

SQL Server 2005 Forums

Other SQL Server Topics (2005)

SQL 2005, Database Mail

Author

Topic

Kijlarn
Starting Member

1 Post

Posted - 2008-01-24 : 10:44:33

I recently got the datamail setup and running. I am able to use database test mail to successfully send a test email relay through the SMTP port of the exchange server and then out to the appropriate email adress.

When i use the SP_Send_Dbmail it says Mail Queue. I check the sysmail_allitems it says the Sent_Status is sent but I never receive it.

Everything below executes just fine and places the right information in the right msdb tables. I just never receive the email. Any suggestions on where to look? Service_broker messages is enabled and i restart sqlserveragent also.

use msdb
go

exec msdb..sysmail_start_sp
go

EXEC msdb..sp_send_dbmail
@profile_name = 'DBuser'
@recipients = 'user@yahoo.com',
@subject = 'Test',
@body = 'Test',
@body_format = 'HTML'

Sara Karasik
Starting Member

10 Posts

Posted - 2008-02-13 : 10:39:25

Check the settings on your exchange (or whatever mail server you are using).

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources