REPOST: Re: Stop/kill runnind dbms_job process ?

"Henry" <henry_2303_at_hotmail.com> wrote in message news:<a2ptsd$499_at_dispatch.concentric.net>...
> Is there a way to do it ?
>
> 1. dbms_job.remove ... does not stop running job
>
> 2. alter system kill session ...
> in my testing example it returns ORA-00031: session marked for kill but then
> it creates new session with same sid but new serial# and remains there even
> is my testing job is one-time run only (the interval parameter for job is
> null).
> The second thing is that for alter system kill session you need system
> privileges and I would like to be able to do it from application (user
> account).

Henry,
what you can do is
1) dbms_job.broken
2) alter system kill session
now it should be stopped permanently. Make a procedure of it owned by a user that has the correct privs and grant the procedure to a user role. A normal user can call the proc and uses the privileges of the proc owner.

Ronald.

• WAS CANCELLED BY =======: From: devnull_at_ronr.nl (Ronald) Control: cancel <67ce88e7.0201250119.6b2a4ff3_at_posting.google.com> Subject: cmsg cancel <67ce88e7.0201250119.6b2a4ff3_at_posting.google.com> Date: Mon, 28 Jan 2002 01:32:28 GMT Message-ID: <cancel.67ce88e7.0201250119.6b2a4ff3_at_posting.google.com> X-No-Archive: yes Newsgroups: microsoft.test,alt.flame.niggers,comp.databases.oracle.server NNTP-Posting-Host: w088.z064003087.lax-ca.dsl.cnc.net 64.3.87.88 Lines: 1 Path: news.uni-stuttgart.de!news.fh-hannover.de!unlisys!news.snafu.de!fr.clara.net!heighliner.fr.clara.net!freenix!feed.ac-versailles.fr!out.nntp.be!propagator-SanJose!in.nntp.be!news-in-sanjose!sjc-feed.news.verio.net!sea-feed.news.verio.net!news.verio.net!msrnewsc1!cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp04!u&n&a&c&anceller Xref: news.uni-stuttgart.de control:40723648

This message was cancelled from within The Unacanceller's glorious new software, Lotus 1-2-3 For Rogue Cancellers. Received on Fri Jan 25 2002 - 03:19:39 CST