今天刚上班,收到一条短信,登录服务器,发现一个job运行有问题导致,于是用DBA账户停止该JOB,报如下错误:
SYS@xezf(qs-xezf-db1)> exec dbms_job.broken(25,true);
BEGIN dbms_job.broken(25,true); END;*
ERROR at line 1:
ORA-23421: job number 25 is not a job in the job queue
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_IJOB", line 592
ORA-06512: at "SYS.DBMS_JOB", line 252
ORA-06512: at line 1
由于该JOB 是其他账户的JOB ,非DBA,于是换用下面的方式处理: dbms_ijob
SYS@xezf(qs-xezf-db1)> exec dbms_ijob.broken(25,true);
PL/SQL procedure successfully completed.
SYS@xezf(qs-xezf-db1)> commit;
Commit complete.