My Oracle Support Banner

"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 AUGUST 04, 2018

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.

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

To view full details, 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 a vibrant support community of peers and Oracle experts.