Dropping a job in Oracle 9i

You can drop a job in Oracle 9i with the job number and DBMS_JOB.REMOVE:

SQL> SELECT JOB, SUBSTR(WHAT,1,35), NEXT_DATE, NEXT_SEC, BROKEN FROM
DBA_JOBS;

       JOB SUBSTR(WHAT,1,35)                   NEXT_DATE NEXT_SEC B
---------- ----------------------------------- --------- -------- -
       182 SYS.MYJOB_1;                        03-JUN-10 17:16:39 N
       183 SYS.MYJOB_2;                        03-JUN-10 21:45:21 N
        41 SYS.OTHERJOB_1;                     03-JUN-10 16:13:12 N
        61 SYS.OTHERJOB_2;                     06-JUN-10 08:54:07 N
       204 statspack.snap;                     03-JUN-10 16:13:22 N
       161 SYS.LASTJOB;                        01-JAN-00 00:00:00 Y

6 rows selected.

SQL> EXECUTE DBMS_JOB.REMOVE(204);

PL/SQL procedure successfully completed.

SQL> SELECT JOB, SUBSTR(WHAT,1,35), NEXT_DATE, NEXT_SEC, BROKEN FROM
DBA_JOBS;

       JOB SUBSTR(WHAT,1,35)                   NEXT_DATE NEXT_SEC B
---------- ----------------------------------- --------- -------- -
       182 SYS.MYJOB_1                         03-JUN-10 17:16:39 N
       183 SYS.MYJOB_2;                        03-JUN-10 21:45:21 N
        41 SYS.OTHERJOB_1;                     03-JUN-10 16:13:12 N
        61 SYS.OTHERJOB_2;                     06-JUN-10 08:54:07 N
       161 SYS.LASTJOB;                        01-JAN-00 00:00:00 Y