On Tuesday 06 June 2006 07:13, Ronald Breuer wrote:
> Hi,
>
> find the job_number via
>
> SQL> Select job, substr(what,1,200) from DBA_JOBS
>    2  ;
>
>         JOB SUBSTR(WHAT,1,200)
> ---------- --------------------------------------------
>           3 index_optimize();
>
> SQL> execute dbms_job.remove(3);
>
> This currently does not stop a running job.
> ...

You also need a COMMIT after this for the action to take effect.

DBMS_Job can only be used for jobs you own.  Otherwise, if you have
sufficient privileges (e.g., DBA role), you can use Sys.DBMS_IJob instead:
same functionality but lets you manipulate all jobs versus just the stuff
you own.  There is no PUBLIC SYNONYM for it, so you will need the "Sys."
schema qualification.

Barry J.

--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting