Why is the email not coming to me from DB

Question

Why is the email not coming to me from DB

mw_sql_developer

SSCoach

Points: 19445
More actions
December 21, 2016 at 3:56 pm

#332914

See attached file.
It does not give an error but also I do not receive an email ( I did replace the actual email addresses for security reasons )
Now if I run the same SP in another server, I get the same output but I also receive the email coming to my gmail.
How can we further troubleshot ?

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

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

Lowell SSC Guru Points: 323518 More actions · Answer 1

look to see what database mail has to say about the specific message; it could be that a firewall issue prevents connections, or you misspelled a password or something:

SELECT top 100

mail.send_request_date As SentDate,

sent_status As Reason,

err.[description],

mail.*

FROM [msdb].[dbo].[sysmail_allitems] mail

inner join [msdb].[dbo].[sysmail_event_log] err

ON err.mailitem_id = mail.mailitem_id

WHERE mail.sent_status <> 'sent'

order by mailitem_id desc

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!

Ed Wagner SSC Guru Points: 287026 More actions · Answer 2

Run Lowell's query on the server that isn't sending the email. If you haven't set up database mail, it won't send.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

mw_sql_developer SSCoach Points: 19445 More actions · Answer 3

mw_sql_developer

SSCoach

Points: 19445

December 22, 2016 at 8:28 am

#1919354

Ed: It used to send , suddenly it stopped.

Ed Wagner SSC Guru Points: 287026 More actions · Answer 4

mw112009 (12/22/2016)
Ed: It used to send , suddenly it stopped.

Is database mail still set up correctly? What did Lowell's query return?

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions