Re: Job starting problem

From: Joe Yung <joeyung_at_gmail.com>
Date: Wed, 16 Feb 2005 22:24:53 +0800
Message-ID: <cuvl3m$dse6@imsp212.netvigator.com>

fitzjarrell_at_cox.net wrote:
> 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
>

Hi,

After submitting your job by DBMS_JOB package, commit it, it is a known issue in 9i.

begin

   dbms_job......;
   commit;
end;
/

Joe Received on Wed Feb 16 2005 - 08:24:53 CST