My Oracle Support Banner

ORA-01873 thrown by DBMS_SCHEDULER.DROP_JOB and DBMS_SCHEDULER.STOP_JOB (Doc ID 1680447.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 and later
Information in this document applies to any platform.

Symptoms

On trying to stop or remove jobs, the customer gets the following errors


SQL> exec dbms_scheduler.stop_job ('ORACLE_OCM.MGMT_STATS_CONFIG_JOB', force=>true)
BEGIN dbms_scheduler.stop_job ('ORACLE_OCM.MGMT_STATS_CONFIG_JOB', force=>true); END;

*
ERROR at line 1:
ORA-01873: the leading precision of the interval is too small
ORA-01873: the leading precision of the interval is too small
ORA-06512: at "SYS.DBMS_ISCHED", line 168
ORA-06512: at "SYS.DBMS_SCHEDULER", line 515
ORA-06512: at line 1

SQL> exec dbms_scheduler.drop_job('ORACLE_OCM.MGMT_STATS_CONFIG_JOB', force=>true);
BEGIN dbms_scheduler.drop_job('ORACLE_OCM.MGMT_STATS_CONFIG_JOB', force=>true); END;

*
ERROR at line 1:
ORA-01873: the leading precision of the interval is too small
ORA-01873: the leading precision of the interval is too small
ORA-06512: at "SYS.DBMS_ISCHED", line 182
ORA-06512: at "SYS.DBMS_SCHEDULER", line 615
ORA-06512: at line 1

 

Changes

 No Changes

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.