ORA-23421: job number string is not a job in the job queue

在用sys用户执行EXEC DBMS_JOB.REMOVE(103)的时候，报ora-23421的错误。

其中job number 103的job是另外一个用户下的job.

 

Error Messages中是这么解释的

ORA-23421: job number string is not a job in the job queue
Cause: There is no job visible to the caller with the given job number.
Action: Choose the number of a job visible to the caller.

 

切换到dba_jobs.log_user用户下，重新执行EXEC DBMS_JOB.REMOVE(103)；

运行通过。