Re: Stopping Oracle Jobs

amerar_at_iwc.net schrieb:

> 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???

Consider a revoke of a grant needed by the running job. Oracle wants to assure that a revoke becomes effective in the moment, the revoke is executed. (Even, if a additional grant does not effect the job directly). So every job creates a JQ lock to prevent concurrent grant/revoke statements.

>
> 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........

A job session is not killed by DBMS_JOB.REMOVE. It runs and runs and runs. Actually, the job is just not started again when finished. Convince yourself via v$session. Received on Fri Aug 11 2006 - 16:09:17 CDT