Job details (10g+)

March 2nd, 2012
SET LINESIZE 200
SET PAGESIZE 9999
SET VERIFY   OFF

COLUMN owner	  FORMAT a15   HEADING 'Owner'
COLUMN job_name   FORMAT a30   HEADING 'Job Name'
COLUMN job_action FORMAT a50   HEADING 'Job Action'
COLUMN next_date               HEADING 'Next Run Date'
COLUMN repeat_interval   FORMAT a30   HEADING 'Interval'
COLUMN last_date               HEADING 'Last Run Date'
COLUMN enabled     FORMAT a9    HEADING 'Enabled?'

select 
	owner,
	job_name, 
	job_action,
	TO_CHAR(next_run_date, 'DD/MM/YYYY HH24:MI:SS') next_date,
	repeat_interval,
	TO_CHAR(last_start_date, 'DD/MM/YYYY HH24:MI:SS') last_date,
	enabled
FROM dba_scheduler_jobs
/
Comments are closed.