Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Restart DBMS_JOBS
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 Thu Feb 02 2006 - 13:45:34 CST