"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 FEBRUARY 02, 2022
Applies to:Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
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
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