Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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');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