Home Which Job inserted this record / row into the table?
Reply: 0

Which Job inserted this record / row into the table?

user302
1#
user302 Published in April 27, 2018, 6:51 am

I have dozens of different SQL Jobs calling different Sprocs, which insert rows into a common table.

Is there any way, given a row in the table, to retrieve the job which triggered the insert?

Input: Row ID, TableName, DBName

Output: Job ID which inserted Row

You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.388534 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO