If I then immediately reset it to Broken = 'N', will it go right back into
the job queue and process at the next interval?
"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
news:v4o3q3jkrk3la2_at_corp.supernews.com...
> 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 - 16:18:14 CST
