From: brittneym@my-deja.com
Subject: DBMS_JOBS: job executes, but only works first time
Date: 2000/08/08
Message-ID: <8mq492$lj7$1@nnrp1.deja.com>#1/1
X-Http-Proxy: 1.1 x67.deja.com:80 (Squid/1.1.22) for client 63.99.155.196
Organization: Deja.com - Before you buy.
X-Article-Creation-Date: Tue Aug 08 23:14:44 2000 GMT
X-MyDeja-Info: XMYDJUIDbrittneym
Newsgroups: comp.databases.oracle.server
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 4.01; Windows NT)


Hello all-
I have a procedure which works fine on its own- it deletes rows from a
table when
certain conditions are met. I set up a job which 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- any new data inserted since the last run just sits there,
never removed by the procedure.
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.