dbms_jobs is not executing properly

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');

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