Just set the job to broken
--
Sybrand Bakker
Senior Oracle DBA
to reply remove '-verwijderdit' from my e-mail address
"Ryan" <rgaffuri_at_cox.net> wrote in message
news:Q0U2a.1842$4F3.49251_at_news2.east.cox.net...
> I dont want to remove the job from the queue. I want to kill the process
> that is running.
>
> anyone know how to dynamically use kill session?
>
> "Jan Gelbrich" <j_gelbrich_at_westfalen-blatt.de> wrote in message
> news:b2godt$1cb25g$1_at_ID-152732.news.dfncis.de...
> > Hi !
> >
> > If you are talking about DBMS_JOBS, then I regret to say that killing
> > session of those job
> > is not possible in the normal way by KILL SESSION. The only ways to stop
a
> > job are
> >
> > DBMS_JOB.REMOVE( )
> > (job owner user can do it)
> > or
> > set the job to 'broken' (even if it runs fine, but it will not be
started
> in
> > that case).
> > (job owner user can do it)
> > or
> > ALTER SYSTEM set job_queue_processes = 0
> > (that is: stop *all* jobs, only DBAs should be doing that.)
> >
> > The reason for it is that the job session is not a normal user session
by
> > login, it is created by
> > an Oracle background process. The session "username" is USER, having no
> > terminal in v$session,
> > and being permanently active.
> > Anf even if You succeded to kill it, it will be re-opened by Oracle
> withing
> > job_queue_interval automatically.
> >
> > hth
> >
> > Jan.
> >
> > "Ryan Gaffuri" <rgaffuri_at_cox.net> schrieb im Newsbeitrag
> > news:1efdad5b.0302131021.3bef58bb_at_posting.google.com...
> > > this is dying on me. is there a way to do this dynamically?
> > >
> > > EXECUTE IMMEDIATE 'ALTER SYSTEM KILL SESSION '':1,:2''';
> > > USING v_sid, v_serial#;
> > >
> > > I have a requirement to allow users to be able to kill a job that is
> > > running. only way to do that is to kill the session. So Im giving them
> > > a wrapper.
> >
> >
>
>
Received on Thu Feb 13 2003 - 15:29:35 CST
