oracle 查看 job执行是否成功
select t.owner,
t.job_name,
t.status,
to_char(t.actual_start_date, 'yyyy-mm-dd hh24:mi:ss'),
t.additional_info,
t.error#
from dba_scheduler_job_run_details t
where t.job_name in ('JOB_SYCN_ORG_SALES','JOB_SYCN_AGENT_DATA') --job名字
order by log_date desc;