zOs/SQL/REOPART

select j.job, p.*, p.tst
    from s100447.treoRunJob j
       , s100447.treoRunPart p
    where j.tst = p.tst
      and p.tst > current timestamp - 24 hour
    order by p.tst desc, rng, part