Mail sending problem from sql server

Question

mail is configured in sql server and it sends mail properly but sometime when i send mail from sql server then i saw the message like "Mail queued." but i dont get the mail. so then i check the mail status by a sp like EXEC msdb.dbo.sysmail_help_queue_sp @queue_type = 'mail'; then i see the mail state is NOTIFIED. then i just stop and start the mail queue using sp called sysmail_stop_sp and sysmail_start_sp. it is often happening in my sql server mail is getting queued but not sending. i am not being able to catch the problem why often my sql server mail state becomes Notified. please help me that how could get come out from this problem.

Remus Rusanu · Accepted Answer · 2011-01-20 06:50:08Z

3

NOTIFIED means the DB Mail process was send an activation message. Until a RECEIVE verb is run on the mail queue, no new notifications will be sent. See Understanding Queue Monitors to understand how this process works.

If your queue remains often in NOTIFIED state it must be that your DB Mail process crashes often. Look into the system event log for clues why this is the case.

answered Jan 20, 2011 at 6:50

Remus Rusanu

296k42 gold badges459 silver badges583 bronze badges

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

Collectives™ on Stack Overflow

Mail sending problem from 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