Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> DBMS_JOB: executes, but only seems to work once

DBMS_JOB: executes, but only seems to work once

From: <brittneym_at_my-deja.com>
Date: 2000/08/08
Message-ID: <8mq42j$lif$1@nnrp1.deja.com>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US