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

Home -> Community -> Usenet -> c.d.o.server -> dbms_jobs is not executing properly

dbms_jobs is not executing properly

From: senthil <rsenthilkumar_at_my-deja.com>
Date: 2000/07/24
Message-ID: <8lhrfn$t6g$1@nnrp1.deja.com>#1/1

hi there,

i am trying to insert a row to a particular table on everyday. here the code looks like this,

declare

   vjobno := number;
begin

   dbms_job.submit(vjobno,

                   what=>'insert into emp (this_day) values (sysdate)',
                   next_date=>trunc(sysdate)+1,
                   interval=>'trunc(sysdate+1)+1');
end;

is there anything wrong in it. but the job is not running at the specified time.

Any suggestion is appreciated.

thanks,
senthil.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Jul 24 2000 - 00:00:00 CDT

Original text of this message

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