Scheduler jobs monitoring?

Is there any handy SQL sentence to be used for scheduler jobs monitoring?

Initially I thought that this would be trivial: checking FAILURE_COUNT and STATE from DBA_SCHEDULER_JOBS.

However I found out that I have a failing job with state "SCHEDULED"´ and zero FAILURE_COUNT and having error messages in the table SCHEMA.run_details.

There are no related errors in alert.log.

I tried DBA_SCHEDULER_JOB_RUN_DETAILS too, ERROR#<>0 didn't help.

The best solution I was able to create was;

SELECT RUN_DETAILS_ID,RUN_DETAILS_RUNS_ID, RUN_DETAILS_CREATED_DATE, run_details_error_details, RUNS_SJ_ID, sj_job_name