SQL 2005 dbmail can not Send?

Recently, SQL Server 2005 DatabaseMail can not Send Mail, and before it was normal.

Execute below command:

EXEC msdb.dbo.sysmail_help_status_sp

--result STARTED

EXEC msdb.dbo.sysmail_help_queue_sp @queue_type = 'mail'

--result

queue_type length state          last_empty_rowset_time  last_activated_time
----------------------------------------------------------------------------------
mail       1     INACTIVE    2009-10-29 05:37:56.673    2009-10-29 05:37:56.673

When Send Test E-mail, "Length" Field Auto increment in Statement 2 ,But "State" Field always stays Inactive

asked Oct 29, 2009 at 03:12 AM in Default

yjj
11 ● 1 ● 1 ● 3

(comments are locked)

1 answer:

The status of INACTIVE just means that at the time of running the query, the queue isn't doing anything, it doesn't mean it is turned off, or not operating correctly.

Your items are queuing up, so I would suggest looking at whatever you have set up as the mail server, to see whether it is still functioning, and whether SMTP services are running correctly.

Also check this link on TechNet, it will guide you through checking the sysmail_event_log.

answered Oct 29, 2009 at 06:27 AM

Kev Riley ♦♦
66.8k ● 48 ● 65 ● 81