ora-23421 job number 1 is not a job in job queue
Hi All,
Today we encountered a strange error i.e ora-23421 when trying
to remove a job from the job queue.
When we try to query the job in dba_jobs queue we found the job with job#=1
to be present
also when the job was running when we queried dba_job_running we found job
with job#=1
But when we try to remove the job using dbms_job package we got the above
error ora-23421.
SQL> conn sys as sysdba
SQL> exec dbms_job.remove(1);
ora-23421 job number 1 is not a job in job queue
All the above activities were carried out by logging as sysdba user.
In other words we tried to remove the job which was was created and scheduled
by some other user with sysdba user and as a result we got the above error.
Later on we queried priv_user column of the dba_jobs view for that job and
logged into the database with that user and removed the job with the same
dbms_job package
and the job was removed succesfully.