www.oracle-wiki.net SQL Library
-- -- 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 /