`

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

 
阅读更多

SQL> exec dbms_job.remove(204);
BEGIN dbms_job.remove(:job_no); END;

*
ERROR at line 1:
ORA-23421: job number 204 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

换成job owner执行就没有问题了。

SQL> exec dbms_job.remove(64);

PL/SQL procedure successfully completed.

SQL>

分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics