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.

Kind Regards
Ronald


On 06.06.2006 12:46 Wendlandt, Guido wrote:
> Hi @ all,
>
> Long time ago I have created a local DB-Job on oracle 10g R2 using the old
> tool "Oracle Replication Manager v2.0".
>
> By changing something inside the database I want to remove the job. But the
> Replication Manager could not remove it (ORA-23421).
>
> The job is not shown on the 10g Enterprise Manager.
>
> Can you please tell me how to remove the job from the database.
>
>
>
> Mit freundlichen Gr??en / Yours sincerly
>
>
>
> Guido Wendlandt
>
>
>
>
>
> ________________________________________________
>
> Georgsmarienh?tte GmbH
>
> Neue H?ttenstra?e 1
>
> 49124 Georgsmarienh?tte
>
> Tel.: +49-(0)5401-394723
>
> FAX: +49-(0)5401-394598
>
> Mobil: +49-(0)170-7857345
>
> <http://www.gmh.de> http://www.gmh.de
>
>
>
>
>
>
>
>


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