Strange dbms_job problem

From: <sascha_kiefer_at_my-deja.com>
Date: 2000/06/05
Message-ID: <8hfn22$ing$1@nnrp1.deja.com>#1/1

Hi,

I tried to creat a job, that runs every hour. I used the following statements:

variable :jobnr number

begin
dbms_job.submit (:jobnr, 'Pik_Bbm_Ebna_Utils01001.CreateYesterdayLog;', sysdate, 'sysdate+1');
commit;
end;

normally it should run directly and then every hour. In the table user_job the entry is correct, but the job dosen't work.

When I use dbms_job.run (22) the program does what I expect.

What's wrong ?

Thanks
Sascha

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Jun 05 2000 - 00:00:00 CDT