On Mar 27, 9:44 am, "Darstan" <rseckst..._at_gmail.com> wrote:
> 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.
Have you tried to set JOB_QUEUE_PROCESSES to 0?
Received on Wed Mar 28 2007 - 10:23:18 CDT
