No new posts notification recently. Just know lot of new posts on this topic.
Yes, neoID is right a sql job is not re-entrant. However it does not affect the solution suggested. The triggger does not call a predefiend job. The solution is to create a one time job each time in the trigger and start it. So the calling client is released. The jobs should have unique names to avoid overwriting. It's easy to have some name convention for the job.
Not sure about the updating rate on the table. This solution is not for heavy updating load becuase creating and starting a job is expensive. It's just a possible way to asynchronously process data.