Stopping Oracle Jobs

Hi All,

We are running Oracle 9.2.0.7. We have a number of jobs running in the queue. A few things have become an issue here.

First, if we need to re-compile a stored procedure that is being used by one of the jobs, the job must first be stopped. Strangely enough, even if we want to issue a simple grant to a table or on a procedure, we cannot as long as the object is being used......?? Why???

However, even if we use DBMS_JOB.REMOVE to remove the job from the queue, for some reason the JQ locks are never released, and thus I cannot comple or grant. I need to manually go and kill the session........

Any thoughts or ideas?

Thanks! Received on Thu Aug 10 2006 - 15:03:20 CDT