Re: dbms_jobs is not executing properly

Also (on 8.0.5.1) there is a bug in dbms_jobs that requires the resource_limit to be FALSE (in your initsid.ora) - If you're using resource limit's, you can't use dbms_job scheduling.

On Tue, 25 Jul 2000 12:23:00 +0200, Arndt Binninger <A.Binninger2_at_deutschepost.de> wrote:

>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