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, 2009 at 03:12 AM in Default

avatar image

yjj
11 1 1 3

(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, 2009 at 06:27 AM

avatar image

Kev Riley ♦♦
63.8k 48 61 81

(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.

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:

x2016
x34

asked: Oct 29, 2009 at 03:12 AM

Seen: 2541 times

Last Updated: Oct 29, 2009 at 06:25 AM

Copyright 2016 Redgate Software. Privacy Policy