Oracle PL/SQL/System Tables Views/DBA JOBS RUNNING

Viewing Executing Jobs

   <source lang="sql">

SQL> -- SQL> SQL> SELECT SID,JOB,THIS_SEC,FAILURES

 2  from DBA_JOBS_RUNNING
 3  where rownum < 50;

no rows selected SQL> SQL> SQL> --

</source>