Job starting problem -
02-16-2005
, 02:45 AM
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 |