I bet your job is repeating itself because there are unhandeled exceptions in your procedure. What does the following query return:
SELECT failures, total_time, last_sec, this_sec, next_sec last_date, next_date FROM user_jobs
WHERE job_id = 41; -- or whatever your job number is




Reply With Quote