Lazy dbms_job

  • From: Ranko Mosic <ranko.mosic@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 21 Apr 2005 09:24:46 -0400

I am running following procedure ( Oracle 9i ):=20

dbms_job.submit( l_job, 'background_submit_proc( JOB, NEXT_DATE);' );

create or replace
    procedure background_submit_proc( p_job in number, p_NEXT_DATE OUT DATE=
               uui(); -- these are procedures that are executed;

=09p_next_date :=3D sysdate + 1/24/60/60*1;

    exception when others then raise;

Whole thing runs fine. It modifies NEXT_DATE so it reschedules itself
as soon as
3 procedures are finished. Procedures are very fast ( takes less than
a second to execute them ). So job's NEXT_DATE should be incremented
almost every second.
It is not. It is incremented every 15 seconds.=20
Is there a way to make it more responsive ? I want it to execute every seco=
nd .=20

Regards, Ranko.

Other related posts: