Oracle PL/SQL Tutorial/System Tables Data Dictionary/dba jobs running

Join dba_jobs_running and dba_jobs

SQL>
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>