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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Job starting problem

Re: Job starting problem

From: IANAL_VISTA <IANAL_Vista_at_hotmail.com>
Date: Wed, 16 Feb 2005 15:35:37 GMT
Message-ID: <Xns95FF4D3FAB394SunnySD@68.6.19.6>


"Wojtek Wawrzyniak" <wojciech.wawrzyniak_at_quantum.pl> wrote in news:cuv199$4q4$1_at_atlantis.news.tpi.pl:

> Hi,
> I have a problem with jobs -after creating a job
> when goes time of its execution nothing happens.
> When I start job manually (dbms_job.run) it starts,
> but on next execution time nothing happen again.
> This is Oracle9i (Enterprise Edition Release 9.2.0.4.0) databease,
> the job_queue_processes parameter is set to 1,
> the job_queue_interval is not set (it is not used in this version, but
> even set it not help).
> Restart of database does not help, last time after restart of server
> it start work,
> but It can not do this to often.
> Any ideas, what I can check?
>
> Regards,
> Wojtek
>
>
>

Try issuing a COMMIT after the DBMS_JOB line. ;-) Received on Wed Feb 16 2005 - 09:35:37 CST

Original text of this message

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