SQL>
SQL> SELECT a.job, what,
2 TO_CHAR(SYSDATE, 'mm/dd/yyyy hh24:mi:ss') now,
3 TO_CHAR(a.this_date, 'mm/dd/yyyy hh24:mi:ss') this
4 FROM dba_jobs_running a, dba_jobs b
5 WHERE a.job = b.job and rownum < 50;
no rows selected
SQL>