From: brittneym@my-deja.com
Subject: DBMS_JOB: executes, but only seems to work once
Date: 2000/08/08
Message-ID: <8mq42j$lif$1@nnrp1.deja.com>#1/1
References: <8ltmuo$mnn$1@nnrp1.deja.com>
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:11:17 2000 GMT
X-MyDeja-Info: XMYDJUIDbrittneym
Newsgroups: comp.databases.oracle.misc
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 4.01; Windows NT)


Hello all-
I 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.