zlacker

But it's the same thing every time. Turn autocommit off, run the SELECT, commit, repeat? Or am I missing something?

>>RedShi+(OP)
You just do the update with skip locked and finish the job until time runs out or update the job "liveness". (can be autocommit on & off)