1检查作业日志：SELECT log_date, status, additional_info FROM dba_scheduler_job_run_details WHERE job_name = '<JOB>';
2验证脚本是否存在且可执行：ls -la <script_path>
3以 Oracle 操作系统用户手动测试脚本
诊断命令
SELECT log_date, status, additional_info FROM dba_scheduler_job_run_details WHERE job_name = '<JOB_NAME>' ORDER BY log_date DESC FETCH FIRST 5 ROWS ONLY;