Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Restart DBMS_JOBS
Gentlemen,
I did trace the job and it did not fail.
It seems to happen just once and a while for short running jobs.
I will suggest to upgrade it, just as some of you recommanded.
Thanks for your replies.
Kind Regards,
Ben de Boer
"NetComrade" <netcomradeNSPAM_at_bookexchange.net> wrote in message
news:p7o4u155jqkefgd3bccp5o07jbk1ek331h_at_4ax.com...
> On Thu, 2 Feb 2006 09:06:11 +0100, "Ben de Boer" <cbdeboer_at_planet.nl>
> wrote:
>
> >Hi everybody,
> >We run an Oracle database Version 8.1.7.2.0 on a unix machine.
> >For some jobs to run we use DBMS_JOBS.SUBMIT ...
> >Now sometimes, special for short running programs, it will be started a
> >second time,
> >after finishing without errors.
> >Does anybody has some same problems and solved it.
>
>
> You're saying that sometimes a submittied job runs twice? That can
> happen only if you submittied it twice, or it failed the first time..
> You'll need to 'trace' the job ids, and trace the program from within
> itself (e.g. via some log table).
> .......
> We run Oracle 9.2.0.6 on RH4 AMD
> remove NSPAM to email
Received on Fri Feb 03 2006 - 04:03:22 CST