2 DBMS_JOB Questions

From: Ed <ed_at_mail.com>
Date: Thu, 8 Mar 2007 15:21:22 -0500
Message-ID: <12v0s23ieuhaqfe@corp.supernews.com>

2 questions about dbms_job on 10g
this is just "call-a-storedproc-once-immediately" --- so it failed

1. Is there an option to NOT let Oracle retry the job again ?
2. I did this : DBMS_JOB.REMOVE(334) ~ DBMS_JOB.REMOVE(337) But the SQL below is still displaying the Jobs....is this right ?

thanks

SQL> SELECT job, next_date, next_sec, failures, broken, SUBSTR(what,1,40) DESCRIPTION
  2 FROM user_jobs;

       JOB NEXT_DATE   NEXT_SEC                           FAILURES BROKEN 

DESCRIPTION

---------- ----------- -------------------------------- ---------- ------ --------------------------------------------------------------------------------
       334 08-Mar-2007 15:50:19                                  6 N 
mypak.myjob(26,'107374227610
       335 08-Mar-2007 16:00:25                                  6 N 
mypak.myjob(27,'107374245010
       336 08-Mar-2007 16:07:41                                  6 N 
mypak.myjob(28,'107374245710
       337 08-Mar-2007 15:36:22                                  5 N 

mypak.myjob(30,'107374246410 Received on Thu Mar 08 2007 - 14:21:22 CST