Checking Jobs in oracle job scheduler for status

select * from dba_scheduler_job_log  where job_name = 'X';

select * from dba_scheduler_job_run_details where log_id = X order by log_id desc;

 

select log_date,status,additional_info from dba_scheduler_job_run_details where log_id in (select log_id from dba_scheduler_job_log where log_date > sysdate-6/24 and status = 'FAILED' ) order by log_id desc;
select log_id from dba_scheduler_job_log where log_date > sysdate-4/24 and status = 'FAILED' ;
select * from dba_scheduler_job_log where log_date > sysdate-2 and job_name like 'FULL%ADD%' order by log_date desc;
select * from dba_scheduler_jobs;