Recently, SQL Server 2005 DatabaseMail can not Send Mail, and before it was normal. Execute below command:
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
(comments are locked)
|
The status of 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.
(comments are locked)
|