SQL> exec dbms_job.remove(204);
BEGIN dbms_job.remove(:job_no); END;
*
ERROR at line 1:
ORA-23421: job number 204 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 171
ORA-06512: at line 1
换成job owner执行就没有问题了。
SQL> exec dbms_job.remove(64);
PL/SQL procedure successfully completed.
SQL>