July 21, 2014 at 5:23 am
Hello
I need some help with trying to track a email back to who/what sent it and where it is sent from. Basically an email has been sent from my department that know one has ever seen, we believe it to be a legacy report but I am unable to find which database there data is coming through or how it is exactly been sent.
I have found the entry into Database Mail Logs and I have found the process ID (15780); however I am unable to find out what this process ID is ? I cant find anything online about it? does anyone know the name of the table in msdb that I can get this information from ? or point me in the right direction.
I could be wrong and the process ID could not give me the information I need. Any help anyone can give would be greatly appreciated.
Thanks a lot
July 21, 2014 at 6:05 am
from sysmail_sentitems object in msdb you can check by subject the record , also can track send_request_date when it has fired , once done,
check the sql servers jobs which is schedule for that time and check there logic , hope it helps
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply