x

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

more ▼

asked Oct 29 '09 at 03:12 AM in Default

yjj gravatar image

yjj
11 1 1 1

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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.

more ▼

answered Oct 29 '09 at 06:27 AM

Kev Riley gravatar image

Kev Riley ♦♦
50.8k 44 49 76

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1936
x29

asked: Oct 29 '09 at 03:12 AM

Seen: 2090 times

Last Updated: Oct 29 '09 at 06:25 AM