Re: dbms_jobs is not executing properly

senthil wrote:
>
> 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.

Make sure you include a commit after you submit the job...

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse