Mail doesn't get queued and sent

Question

Post reply

Mail doesn't get queued and sent

shahgols

SSCrazy Eights

Points: 9874
More actions
January 27, 2014 at 3:40 pm

#281648

Hi all,
When I try to send mail to some operators, the mail doesn't get queued. There are no entries in sysmail_allmails and in sysmail_event_log tables. If I send a direct email to the people in those operators, then the emails are queued and sent just fine. I have stopped and restarted the mail service to no avail. Any help or ideas would be appreciated. Thanks.

Viewing 6 posts - 1 through 5 (of 5 total)

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

mamssjc Valued Member Points: 61 More actions · Answer 1

Hi.

You verified if the DatabaseMailEnabled and OleAutomationEnabled are true in the Facets option of Instance ?

shahgols SSCrazy Eights Points: 9874 More actions · Answer 2

Yes, I just did and they are enabled. There are other operators that have no mail issues. I don't know why certain operators have issues with mail.

mamssjc Valued Member Points: 61 More actions · Answer 3

You send an email to multiple destinations or send an email to a destination within a repetition structure?

You may want to use the second option.

mamssjc Valued Member Points: 61 More actions · Answer 4

1 email -> destination1, destionation2, destionation3...

or

for i = 0 to N

1 email -> destination(i)

Lowell SSC Guru Points: 323518 More actions · Answer 5

can you show details, and not any pseudo code?

if you can show us the exact code you are using to send the emails, we can help you track down the specific errors.

chances are it's something basic;

if one of the parameters is incorrect when you use sp_send_dbmail, the mail would raise an error, which is probably not visible in the job,and never enter the queue. then it might be the job step goes to teh next step instead of reporting the error.

are you sending to multiple recipients in the @recipients parameter? are you sure they are separated by semicolonsand not by commas?

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!