SET lINes 200
SET pagesize 100 
COL owner for a10
COL job_name for a30
COL actual_start_date for a20
COL STATUS for a10
COL RUN_DURATION for a20
COL additional_INfo for a60
SELECT 
	owner, 
	job_name, 
	status, 
	error#, 
	TO_CHAR(actual_start_date, 'dd/mm/yyyy hh24:mi:ss') actual_start_date, 
	run_duration, additional_info 
FROM 
	dba_scheduler_job_run_details
WHERE 
	job_name ='SYNC'
ORDER BY 5;