Re: Removing Submitted jobs

If you have create any procedure privilege you could try the following create or replace procedure <job_owner>.remjob is
begin
dbms_job.remove();
end;
exec <job_owner>.remjob

Hth,

--
Sybrand Bakker, Oracle DBA
Christopher Spence <cspence_at_delphi-tech.com> wrote in message news:BJLiN8sIdQxUcCjgEbGHwT7GYLtr_at_4ax.com...
> is there a way to remove a job from queue without logging in as that
> user? DBMS_JOB.REMOVE() only works logged in under schema for some
> strange reason.
>
Received on Fri Sep 17 1999 - 14:28:23 CDT