Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Restart DBMS_JOBS

Re: Restart DBMS_JOBS

From: Ben de Boer <cbdeboer_at_planet.nl>
Date: Fri, 3 Feb 2006 11:03:22 +0100
Message-ID: <drv9pd$6dko$1@news3.infoave.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US