Oracle notes: delete non-ownerjob

An error is reported when you try to use sys to delete a user's job. You should use REMOVE under DBMS_IJOB to process the error. SQLgt; ExecDBMS_JOB.REMOVE (62 );

An error is reported when you try to use sys to delete a user's job. You should use REMOVE under DBMS_IJOB to process the error. SQLgt; Exec DBMS_JOB.REMOVE (62 );

Delete A non-owner job
An error is reported when you try to use sys to delete a user's job. You should use REMOVE under DBMS_IJOB to process the error.
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-

,