Re: Oracle 9.2 Scheduler problem

"Darstan" <rseckstein_at_gmail.com> wrote in message news:1175003075.008219.102210_at_n59g2000hsh.googlegroups.com...
>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.
>

Did you issue a COMMIT after removing the old jobs ? If not, they were not removed. Received on Sat Mar 31 2007 - 05:49:27 CDT