"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 22.214.171.124 to 126.96.36.199 [Release 8.1.7 to 11.2]
Oracle Database - Enterprise Edition - Version 188.8.131.52 to 184.108.40.206 [Release 11.2]
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!