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 |
|
Carat
Yak Posting Veteran
92 Posts |
 Posted - 2009-04-21 : 09:49:56
|
| For the past 3 years the Database Mail of our production server worked properly until yesterday. Mails are queued but they are not sent to recepients.I checked everything:- Database Mail is enabled (sp_configure)- Server Broker is enabled in the Msdb database (sys.databases)- SQL Server Agent properties / Alert System / enable mail profile checkedResult of 'exec sysmail_help_queue_sp':mail 1 INACTIVE 2009-04-21 13:34:02.503 2009-04-21 13:34:02.240status 0 INACTIVE 2009-04-21 13:13:45.747 2009-04-21 13:13:45.747Result of 'exec dbo.sysmail_help_status_sp':STARTEDI executed 'exec dbo.sysmail_start_sp'.When I send a Test email or when I send an email in sql server (sp_send_dbmail) it is not logged in the table 'sysmail_allitems'. But I get a message that the mail is queued. In the Database Mail Log nothing is added.Whenever I execute DatabaseMail90.exec manually all the emails are delivered and I can see them in the table 'sysmail_allitems'.I already restarted the SQL Server Agent service but the problem is still there.What can I do to solve this problem?Thanks. |
|
|
|
|
|
Problem with Database Mail