Re: Stopping Oracle Jobs

amerar_at_iwc.net wrote:
>
> 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!

"remove" will stop your job from running *again*.

"kill session" will stop the job that is running *now*.

hth

-- 
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
Co-author: "Oracle Insight - Tales of the OakTable"

web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com


"Semper in excremento, sole profundum qui variat."

------------------------------------------------------------