Re: jobs scheduled but it will not run.

Run this query and look at VALUE.

select * from v$parameter where name ='job_queue_processes' order by 2 ;

"Andre" <avanrossem_at_hotmail.com> wrote in message news:4d32d1be.0409192130.96a85fc_at_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 - 01:17:32 CDT