Re: Job starting problem

"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