Re: Job starting problem

From: <fitzjarrell_at_cox.net>
Date: 16 Feb 2005 05:54:05 -0800
Message-ID: <1108562045.623741.245040@z14g2000cwz.googlegroups.com>

Wojtek Wawrzyniak wrote:
> 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

What does the view USER_JOBS tell you about this job? Is it broken? What are the values for NEXT_DATE and NEXT_SEC? Have you tried increasing job_queue_processes?

David Fitzjarrell Received on Wed Feb 16 2005 - 07:54:05 CST