"ORA-23421: job number <job number> is not a job in the job queue" when dropping an existing job (Doc ID 1214884.1)

Last updated on DECEMBER 05, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 8.1.7.4 to 11.2.0.1 [Release 8.1.7 to 11.2]
Oracle Database - Enterprise Edition - Version 11.2.0.4 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.
***Checked for relevance on 06-Aug-2016***

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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms