jq.sql

rem ======================================================================
rem Name:  jq.sql
rem Desc:  Display info about jobs currently running
rem
rem ======================================================================

rem Set the general display parameters for the report:
set pages 55
set lines 79
set pause off
set echo off
set feed 1
set termout on

rem Capture the current date and time:
set termout off
col currdate new_value now
select to_char(sysdate, 'mm/dd/yy hh24:mi') currdate from dual;
set termout on

rem The title for the report:
ttitle left   "jq.sql" -
       center "Job Queue info" -
       right  "Page:" sql.pno  skip 1 -
       right  "Date: " now  skip 3 

SELECT sid, r.job, log_user, r.this_date, r.this_sec
FROM dba_jobs_running r, dba_jobs j     
WHERE r.job = j.job;





spool jq.lst
/
spool off

exit