Oracle笔记：删除非owner job

在尝试使用sys删除一个用户的job的时候报错了，应该使用DBMS_IJOB下的REMOVE来处理即可。SQLgt; Exec DBMS_JOB.REMOVE(62);

删除非owner job
在尝试使用sys删除一个用户的job的时候报错了，应该使用dbms_ijob下的remove来处理即可。
sql> exec dbms_job.remove(62);
 
begin dbms_job.remove(62); end;
 
ora-23421: job number 62 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 174
ora-06512: at line 2
 
sql> exec dbms_ijob.remove(62);
 
pl/sql procedure successfully completed
 
sql> commit;
-the end-

，