List running jobs

--
--  List  running jobs.
--
 
SET PAUSE ON
SET PAUSE 'Press Return to Continue'
SET HEADING ON
SET LINESIZE 300
SET PAGESIZE 60COLUMN owner FORMAT A20
 
SELECT owner,
job_name,
running_instance,
elapsed_time
FROM   dba_scheduler_running_jobs
ORDER BY owner, job_name
/

No comments: