Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> 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
![]() |
![]() |