select * from user_scheduler_job_run_details t where t.LOG_DATE>=date'2018-08-20' and t.STATUS<>'SUCCEEDED'; 执行结果: