Oracle 9.2 Scheduler problem

I am trying to set up a pair of jobs that will execute a SP that grants/revokes a certain users create session privs during during certain hours.

I have the procedures in and working. And the jobs in the scheduler. The jobs fire and it seems to be working.

The problem I have is while I was setting this stuff up I had to test things so I created other jobs that ran at different times so I could test.
Once I was ready to setup the actual jobs I removed all the test jobs. But for some reason oracle is recreating the old jobs and it is not just making one copy of the jobs it is making millions of copies. I came in after the weekend and found that it had made 2.5 million jobs between early Saturday morning and Monday. Only reason it did not keep replicating is the log files filled up the harddrive and archive logging halted all transactions.

Please help me figure out how to get rid of these "ghost" jobs that are being created by oracle and how to stop them from coming back. Received on Tue Mar 27 2007 - 08:44:35 CDT