"ORA-23421: job number <job number> is not a job in the job queue" when dropping an existing job

Last updated on DECEMBER 05, 2016

Applies to:

Symptoms

Trying to drop an existing DBMS_JOB fails with:

SQL> EXECUTE DBMS_JOB.REMOVE(<job number>);

ORA-23421: job number <job number> is not a job in the job queue
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_IJOB", line 529
ORA-06512: at "SYS.DBMS_JOB", line 171
ORA-06512: at line 1

The job is listed in DBA_JOBS, but the procedure DBMS_JOB.REMOVE fails consistently, even when connected as the owner of the job. All preliminary checks have been performed as referenced in the following notes:

<Note 452864.1> DBMS_JOB Remove Procedure Fails With ORA-23421
<Note 1029977.6> ORA-23421 OR ORA-03421 TRYING TO ALTER A JOB

Changes

None

Cause