Getting error while sending mail using SQL Server

Question

I am using the sp_send_dbmail stored procedure of SQL Server and often getting error message:

Mail not queued. Database Mail is stopped. Use sysmail_start_sp to start Database Mail.

After that I used EXECUTE dbo.sysmail_start_sp to start email service again in SQL Server.

What could possibly be causing this error? Does anyone has any idea, then please let me know.

Type in sql server log in your favorite search engine, click the first link. — TT.
– TT., Commented Jul 31, 2017 at 11:57
@TT. is there any way to check weather the mail service is running or stopped in sql server ? — Dhaval Pankhaniya
– Dhaval Pankhaniya, Commented Jul 31, 2017 at 13:42

Trushna · Accepted Answer · 2017-07-31 12:34:31Z

1

I think this will help you...found it from this URLhere After starting the service using sysmail_start_sp run the following script. This will solve the issue

SET NOCOUNT ON
Declare @ch uniqueidentifier;
Declare @message_type nvarchar(256);
Declare @message_body nvarchar(max);
Declare @ctr bigint;
Declare @ctr2 bigint;
While (1=1)
Begin
Receive @ch = conversation_handle, @message_type = message_type_name from ExternalMailQueue
set @ctr2 = @ctr2 + 1
set @ctr = (select count(*) from ExternalMailQueue)
if @ctr = 0 
break
end

answered Jul 31, 2017 at 12:34

Trushna

1206 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Getting error while sending mail using SQL Server

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related