question

artistlover avatar image
artistlover asked

Email job

I have a tblemail that is capturing emails and i cannot find the job anywhere. Does anyone have any ideas as to how i can find the job. I have the email address of who is supposed to be getting it but nothing else.,
dbmail
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Tim avatar image
Tim answered
how often is the table being updated? What version of SQL are you running. The easiest would be a trace, then search the trace for the most recent email added after you started the trace. Might be some extended event trick as well but I haven't played with extended events enought to give an example.
2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Tim avatar image Tim commented ·
Just run your trace a few minutes before 7:00, monitor for new records to come in and stop the trace. You can then search the trace for one of the new records to find the source of the insert statement.
1 Like 1 ·
artistlover avatar image artistlover commented ·
it is updating at 7:00 PM eight times.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.