DBMS_JOBS: job executes, but only works first time

Hello allI
 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. Received on Tue Aug 08 2000 - 00:00:00 CDT