On Mar 8, 3:21 pm, "Ed" <e..._at_mail.com> wrote:
> 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
Did you issue commit after dbms_job.remove?
Received on Thu Mar 08 2007 - 14:44:14 CST
