SQL 2005 dbmail can not Send?

Question

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

Answer 1

0

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 '09 at 06:27 AM

Kev Riley ♦♦
46k ● 38 ● 43 ● 69

(comments are locked)

SQL 2005 dbmail can not Send?

Follow this question

Related Questions