Sql Mail Problem

Question

Sql Mail Problem

Bilichi

Right there with Babe

Points: 741
More actions
May 29, 2008 at 12:34 am

#154394

When i exeute the following statement,
EXEC
msdb.dbo.sp_send_dbmail
@recipients = 'vmsbalaji@gmail.com' ,
@subject = 'TEST' ,@body = 'TEST'
i am getting error as "mail queued".
can u help me to resolve the issue.

Viewing 15 posts - 1 through 14 (of 14 total)

You must be logged in to reply to this topic. Login to reply

alimcitp SSC Eights! Points: 930 More actions · Answer 1

Can you please write the error number and the full message.

Basit Ali Farooq
MCITP Database Administrator
Microsoft Certified Professional Developer (Web Applications)
Microsoft Certified Database Administrator
Microsoft Certified Systems Engineer
Microsoft Certified Systems Administrator
CIW Security Analyst
Cisco Certified Network Associate

Michael Earl-395764 SSC Guru Points: 53873 More actions · Answer 2

That is not an error, it is a message. You will get this message when a mail message is successfully sent to the service broker. In database mail, messages are not sent when you call the procedure. They are sent to a service broker queue and the queue is processed as quickly as possible as messages come in. This makes sending mail an asynchronous process.

If the mail is not actually being sent, check the message queue to make sure the broker queue is being processed. If the queue has been processed, check the logs on your SMTP server.

Bilichi Right there with Babe Points: 741 More actions · Answer 3

can you please explain me how to check the message queue and check the logs on your SMTP server.

Thanks for any help.

rajankjohn SSCertifiable Points: 5061 More actions · Answer 4

you can contact your email server administrator to see why the email is not getting delicvered to the recipient address. If you have an internal email address try that; there can be blocks for external mails. The message you see is not an error; I dont think there is any problem in the db_mail side. See if the post can be of some help -

http://rajanjohn.blogspot.com/2008/04/using-database-mail-in-sql-server-2005.html

Michael Earl-395764 SSC Guru Points: 53873 More actions · Answer 5

The SMTP server logs will depend on the SMTP server you are using. I would suggest you talk to the person who configured the SMTP server.

The message queue is (like all broker queues) just a table. Look in msdb.dbo.ExternalMailQueue and msbd.dbo.InternalMailQueue. Also, there are a number of tables in msdb starting with sysmail that are related to the messages being sent.

Marios Philippopoulos SSC Guru Points: 57190 More actions · Answer 6

In SSMS, right-click on the Database Mail node under Management, and pick View Database Mail Log.

This will give you a list of recent activity along with possible errors.

__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

henri flokstra SSC Eights! Points: 939 More actions · Answer 7

And if the error found there is : Unable to start mail session (reason: No mail profile defined)"

Then: In SQL server Management Studio -> SQL Server Agent -> properties -> Alert System -> Enable mail profile. Give SQL Server Agent a restart.

------------------------------------------------------------
Application Architect and Developer @ Traffic4u
Visit my profile on LinkedIN

Paul Ingham SSC-Addicted Points: 424 More actions · Answer 8

I also find checking the view "sysmail_allitems" usefull if i am having problems it can aoften highlight something obvious.

namrata.dhanawade-1143388 Ten Centuries Points: 1269 More actions · Answer 9

I have a weird problem here.

In my first two attempts, the email was delivered successfully, however now it gives me the message

'Mail queued'

Any reason, why this should happen?

I checked the sysmail_allitems and it has entries of the 1st two successes - when the mail was delivered, but no entry for the ones I have been trying now

Marios Philippopoulos SSC Guru Points: 57190 More actions · Answer 10

namrata.dhanawade (9/15/2009)
I have a weird problem here.
In my first two attempts, the email was delivered successfully, however now it gives me the message
'Mail queued'
Any reason, why this should happen?
I checked the sysmail_allitems and it has entries of the 1st two successes - when the mail was delivered, but no entry for the ones I have been trying now

Try running the following queries to see if you can get some more info:

--get failed messages over last 5 days:

SELECT mailitem_id,* FROM msdb.dbo.sysmail_faileditems

where datediff (day, sent_date, getdate()) < 5

--get mailitem_id from query above and run below to get full error message (description column):

SELECT * FROM msdb.dbo.sysmail_event_log

where mailitem_id = xxxx

__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

namrata.dhanawade-1143388 Ten Centuries Points: 1269 More actions · Answer 11

I was inserting some test data before executing the SP all in one transaction.

I tried it without using a rollback and it worked fine!

Why should an email be queued if it is encapsulated in a transaction?

and thanks for the help anyway..

harman.singh Newbie Points: 5 More actions · Answer 12

harman.singh

Newbie

Points: 5

January 19, 2011 at 9:41 am

#1275398

Hello ali.. how are you mate..

Satnam Singh Hall of Fame Points: 3542 More actions · Answer 13

Whenever any email is sent through SQL u get a message as "Mail Queued"

U can also check the sysmail_mailitems table present in the msdb database. Alternatively u can check the Database Mail Logs also.

Satnam

denise_kelley Newbie Points: 6 More actions · Answer 14

denise_kelley

Newbie

Points: 6

February 4, 2011 at 2:24 pm

#1282712

That means the mail was sent successful.