Is there a way to do it ?
- dbms_job.remove ... does not stop running job
- 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).
Do you have any ideas ?
Thanks.
- WAS CANCELLED BY =======:
From: "Henry" <henry_2303_at_hotmail.com>
Control: cancel <a2ptsd$499_at_dispatch.concentric.net>
Subject: cmsg cancel <a2ptsd$499_at_dispatch.concentric.net>
Date: Mon, 28 Jan 2002 01:49:50 GMT
Message-ID: <cancel.a2ptsd$499_at_dispatch.concentric.net>
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.belwue.de!news.uni-ulm.de!rz.uni-karlsruhe.de!schlund.de!newsfeed01.sul.t-online.de!t-online.de!unlisys!news.snafu.de!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!news.stealth.net!msrtrans1!msrnewsc1!cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp04!u&n&a&c&anceller
Xref: news.uni-stuttgart.de control:40724769
This message was cancelled from within The Unacanceller's glorious new software, Lotus 1-2-3 For Rogue Cancellers.
Received on Thu Jan 24 2002 - 15:21:17 CST