select owner
, job_name
, job_action
, state, failure_count
, max_failures --qtd de falhas que deve ter para ficar broken
, TO_CHAR(last_start_date, 'dd/mm/yyyy hh24:mi:ss') last_start_date
, TO_CHAR(next_run_date, 'dd/mm/yyyy hh24:mi:ss') next_run_date
, last_run_duration
from dba_scheduler_jobs 
where job_name='SYNC';