Re: DBMS_JOB.remove

From: Yong Huang <yong321_at_yahoo.com>
Date: 11 Feb 2003 15:55:29 -0800
Message-ID: <b3cb12d6.0302111555.4a449858@posting.google.com>

sandijs <del_at_one.lv> wrote in message news:<2512749.1044967745_at_dbforums.com>...
> Oracle thinks you are not supposed to and thus you can't do it with
> dbms_job package. But there is an undocumented (and not supported)
> package dbms_ijob which allows you as dba modify/remove any job.

Equally "not supposed to" is create procedure thatuser.tmp as begin execute immediate 'begin dbms_job.remove(thatjob#); end;'.

Yong Huang Received on Tue Feb 11 2003 - 17:55:29 CST