在尝试使用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-
，