Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: dbms_jobs is not executing properly
hi,
you forgot ";" after your insert-statement:
what=>'insert into emp (this_day) values (sysdate);'
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.
Received on Tue Jul 25 2000 - 00:00:00 CDT