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.