Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> DBMS_JOB: executes, but only seems to work once
Hello allI
have a procedure which works fine- it deletes rows from a table when
certain conditions are met. I set up a job which shows seems to be
running okay, executing the procedure every minute. Or at least thats
what the results of this query suggests:
select job, last_date, next_date, next_sec, failures, broken
from user_jobs;
it returns a job number, a last date which seems to update on schedule,
and an appropriate next_date. No failures are listed.
Despite this the procedure does not seem to work after the first time the job runs- the new data inserted since the last run just sits there. If I run the job with dbms_job.run it has the expected results.
Any ideas? Tips for troubleshooting this? This is my first time working with the scheduler.
P.S. values in the init.ora file for
job_queue_processes: 6
job_queue_interval: 10
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Tue Aug 08 2000 - 00:00:00 CDT