jobs scheduled but it will not run.

From: Andre <avanrossem_at_hotmail.com>
Date: 19 Sep 2004 22:30:28 -0700
Message-ID: <4d32d1be.0409192130.96a85fc@posting.google.com>

Hello all,

I have an (oracle 8.1.7.) problem.
I created a job using:

variable jobno number;
begin
  dbms_job.submit (:jobno, 'pckserver.timer;', trunc(sysdate + 1) + 22/24,
  'trunc(sysdate + 1) + 22/24');
  commit;
end;

So every evening at 22:00 hours it must be executed. initially the next-date and the interval are not filled in, but when I manually start the job using the "exec dbms_job.run(29)"; command it does.
Below you can see the select on the jobs which are scheduled: (I manually started the job at 17/9/2004 at 8:41:27)

LOG_USER Job B fail LastDate ThisDate nextDate runInterval WHAT

---------- -------- - ---- ------------------ ------------------
--------------PIPO            29  N  0           17-09-04:08:41:27  :

18-09-04:22:00:00 1.555 pckserver.timer;

But When I view the jobs on the 19th of September nothing was done. I get the same result as above! Why is this job not running?

pckserver.timer is a working procedure (I can start it manually).

Any help would be really appreciated.

Regards,
Anneke Received on Mon Sep 20 2004 - 00:30:28 CDT