11g jobs

August 29th, 2013

11g Auto tasks

SET LINESIZE 200
SET PAGESIZE 9999
SET VERIFY   OFF

COLUMN CLIENT_NAME      		FORMAT a40	HEADING 'Task name'
COLUMN STATUS  					FORMAT a9	HEADING 'Status'
COLUMN MEAN_JOB_DURATION        FORMAT a30	HEADING 'Mean job duration'
COLUMN MAX_DURATION_LAST_7_DAYS FORMAT a30	HEADING 'Max job duration last 7 days'

select CLIENT_NAME, STATUS, MEAN_JOB_DURATION, MAX_DURATION_LAST_7_DAYS from dba_autotask_client
/


Job history

SET LINESIZE 200
SET PAGESIZE 9999
SET VERIFY   OFF

COLUMN log_date_char      	FORMAT a21            HEADING 'Log date'
COLUMN OWNER  				FORMAT a15            HEADING 'Owner'
COLUMN JOB_NAME        		FORMAT a30            HEADING 'Job name'
COLUMN OPERATION        	FORMAT a10  		  HEADING 'Operation'
COLUMN STATUS        		FORMAT a10  		  HEADING 'Status'
COLUMN ADDITIONAL_INFO 		FORMAT a80  		  HEADING 'Additional info'

select to_char(LOG_DATE, 'dd/mm/yyyy hh24:mi:ss') log_date_char, OWNER, JOB_NAME, OPERATION, STATUS, ADDITIONAL_INFO from dba_scheduler_job_log 
	where ADDITIONAL_INFO like upper('%&JOB_info%')
	and log_date > trunc(sysdate) - 30
	order by log_id
/


Comments are closed.