查询DBA_JOBS 发生ORA-01873

刘泽宇

概要
查询DBA_JOBS 发生ORA-01873

ORA-01873: the leading precision of the interval is too small

解决方案
查询 DBA_JOBS 时不要选择列 TOTAL_TIME，选择其他的列来获取信息。

或者

查询 DBA_SCHEDULER_JOBS，可以查到所有的Job，包括通过DBMS_JOB 创建的Job。
select * from dba_scheduler_jobs;


原因
请注意，Scheduler 将不会跟踪Job 的TOTAL_TIME。

Database Preupgrade tool check list. (Doc ID 2380601.1)
Starting with Oracle Database 19c, jobs created and managed through DBMS_JOB package in previous database versions
will be re-created using Oracle Scheduler architecture. Jobs not successfully re-created may not function properly after upgrade.