Job details (10g+)


<br />
SET LINESIZE 200<br />
SET PAGESIZE 9999<br />
SET VERIFY   OFF</p>
<p>COLUMN owner	  FORMAT a15   HEADING 'Owner'<br />
COLUMN job_name   FORMAT a30   HEADING 'Job Name'<br />
COLUMN job_action FORMAT a50   HEADING 'Job Action'<br />
COLUMN next_date               HEADING 'Next Run Date'<br />
COLUMN repeat_interval   FORMAT a30   HEADING 'Interval'<br />
COLUMN last_date               HEADING 'Last Run Date'<br />
COLUMN enabled     FORMAT a9    HEADING 'Enabled?'</p>
<p>select<br />
	owner,<br />
	job_name,<br />
	job_action,<br />
	TO_CHAR(next_run_date, 'DD/MM/YYYY HH24:MI:SS') next_date,<br />
	repeat_interval,<br />
	TO_CHAR(last_start_date, 'DD/MM/YYYY HH24:MI:SS') last_date,<br />
	enabled<br />
FROM dba_scheduler_jobs<br />
/<br />

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
/