March 2, 2007 at 1:41 pm
I have DBMail configured on SQL2005, and have been able to send emails, but there are a large number of emails in the sysmail_unsentitems view. In addition, a test message is also stuck in the unsent items view if I create a test email by right-clicking Database Mail in MSSQL Server Management Studio, and send a test email that way.
It appears that the service broker for the msdb db is running. Running:
SELECT is_broker_enabled FROM sys.databases WHERE name = 'msdb'
returns 1.
In addition, database mail appears to be running; "EXECUTE dbo.sysmail_help_status_sp" returns "Started".
Strangely, when I run:
SELECT * FROM sys.dm_broker_queue_monitors
I can see 2 queues (the state for one is "inactive", and for the other is "notified"), but the last_empty_rowset_time and last_activated_time columns for both queues contain times that are about 6 hours in the future. Here are the results:
database_id queue_id state last_empty_rowset_time last_activated_time tasks_waiting
4 843150049 INACTIVE 2007-03-02 19:08:11.530 2007-03-02 19:08:11.530 0
4 875150163 NOTIFIED 2007-03-02 19:40:28.937 2007-03-02 19:28:53.200 0
Any help/guidance would be much appreciated!
March 13, 2007 at 4:49 am
Hi,
I got the same issue. Whan I start DatabaseMail90.exe manually all messages were sent. I could not find resolution to this issue. The database is MSSQL 2005 Dev without SP1 or SP2. OS is Win2000SP4.
Do you have any idea how to resolv it?
Regards,
Nedko
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply