SStacy2000
Newbie
Points: 3
More actions
May 3, 2016 at 5:33 pm
#318703
I have a SQL job that sends emails. How do you query/return list of emails sent on a certain day given the SQL job name?
Ed Wagner
SSC Guru
Points: 287024
May 3, 2016 at 7:56 pm
#1876473
SStacy2000 (5/3/2016)I have a SQL job that sends emails. How do you query/return list of emails sent on a certain day given the SQL job name?
SStacy2000 (5/3/2016)
Hello and welcome to SQL Server Central.
If your job has procedures that send email using sp_send_dbmail, they're sent through the msdb database.
You can query msdb.dbo.sysmail_mailitems to see the email that's been sent. The send_request_date is the datetime column you'll want to filter on.
Tally Tables - Performance PersonifiedString Splitting with True PerformanceBest practices on how to ask questions
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply