Oracle 8.1.7 docs state you have to own a job to remove it. I would
like to remove another users job. Is the only way to do by doing the
old swap user pw trick?
===
Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D
Try sys.dbms_ijob.remove
Also, remember a job must be broken before it can be removed.
Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, September 23, 2002 2:16 PM
To: Multiple recipients of list ORACLE-L
Oracle 8.1.7 docs state you
:
Please respond toSubject: dbms_job.remove
ORACLE-L
On Mon, Sep 23, 2002 at 01:38:54PM -0800, MacGregor, Ian A. wrote:
Try sys.dbms_ijob.remove
Also, remember a job must be broken before it can be removed.
Thanks for the pointer, maybe not must be broken , this is 8.1.7.4:
SQL select job, what, broken from dba_jobs;
JOB WHAT
No. Try using DBMS_IJOB.REMOVE. It is an undocumented package that can be
used by SYS or a DBA to remove other user's jobs. It is one of the DBAs
secret tools
and should not be shared with lesser mortals. If this code is violated, we
will find you! :)
RWB
Ray Stell [EMAIL