Re: HELP: dbms.job - scheduling job at exact time

AFAIK this isnt possible in Versions < 9 (in 9 and greater i dont know)

you have one (or more) job queque(s). They check every job_queue_intervall (defined in init.ora) for jobs to process. So there will be alway some delay between check and execute.

You could try to set job_queue_intervall very low. Maybe to 1 sec. but you have to check the manuals. Even then it not guaranteed to get 00 sec.

possibly you get more acurate results when triggering the job outside the dbms (cron etc).

regards

s.kapitza

mvapenik_at_cz.soluziona.com (Milan) wrote in message news:<207c3ce7.0306250012.285d2855_at_posting.google.com>...
> Please, has anyone an idea about planning job in axact time ? I mean
> we need to run job in every minute starting at 00 sec. This job takes
> about 2 secs and call another stored procedure.
>
> I wrote this pl/sql block:
>
> declare
> l_job number;
> begin
> dbms_job.submit( l_job,
> 'test_proc;',
> sysdate,
> 'sysdate+1/1440' );
> commit;
> end;
>
> Everything is fine except of submit time. I have no idea about telling
> Oracle to run this job every minute at 00 sec.
>
> Thanks
Received on Wed Jun 25 2003 - 19:30:00 CEST