ERROR at line 1:
ORA-23421: job number 8219 is not a job in the job queue
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_IJOB", line 536
ORA-06512: at "SYS.DBMS_JOB", line 248
ORA-06512: at line 2
如果要停止其它用户的JOB(dbms_job),报以上的错可以换下面方式处理
SQL> exec dbms_ijob.broken(8219,true);
PL/SQL procedure successfully completed.
SQL>
SQL> commit;
Commit complete.