Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Lazy dbms_job

Lazy dbms_job

From: Ranko Mosic <ranko.mosic_at_gmail.com>
Date: Thu, 21 Apr 2005 09:24:46 -0400
Message-ID: <367369f105042106244199628a@mail.gmail.com>


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=   )
    as
    begin

               uui(); -- these are procedures that are executed;
               uui1();=20
               uui2();

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

    exception when others then raise;
end;
/

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.

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Apr 21 2005 - 09:29:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US