Look at the OUTPUT function used with UPDATE.

It was hard to follow your information but would a trigger be a better way than a job that runs every 20 seconds?