zOs/SQL/REOEOJFX

update
         s100447.tReoRunJob a
    set eoj = max(tst, (select min(tst) - 1 seconds
                           from s100447.tReoRunJob u
                           where a.job = u.job and u.tst > a.tst ))
    where eoj >= (select min(tst)
                     from s100447.tReoRunJob n
                     where a.job = n.job and n.tst > a.tst )
;
select *
    from s100447.tReoRunJob a
    where eoj >= (select min(tst)
                     from s100447.tReoRunJob n
                     where a.job = n.job and n.tst > a.tst )
    order by eoj asc
;
commit