Need to remove datapump jobs

All posts relating to Oracle database administration.

Moderator: Tim...

Need to remove datapump jobs

Postby sivakumarocp » Fri May 04, 2012 12:26 am

Hi Tim,

on one of my Prod database has many datapump export jobs.

Code: Select all
JOB_NAME             OPERATION  JOB_MODE   STATE
-------------------- ---------- ---------- -----------
SYS_EXPORT_FULL_01   EXPORT     FULL       DEFINING
SYS_EXPORT_FULL_02   EXPORT     FULL       DEFINING
SYS_EXPORT_SCHEMA_01 EXPORT     SCHEMA     DEFINING
SYS_EXPORT_FULL_03   EXPORT     FULL       DEFINING
SYS_EXPORT_FULL_01   EXPORT     FULL       DEFINING
SYS_EXPORT_FULL_04   EXPORT     FULL       DEFINING
SYS_EXPORT_SCHEMA_02 EXPORT     SCHEMA     DEFINING
SYS_EXPORT_SCHEMA_03 EXPORT     SCHEMA     DEFINING
SYS_EXPORT_FULL_05   EXPORT     FULL       DEFINING
SYS_EXPORT_FULL_06   EXPORT     FULL       DEFINING
SYS_EXPORT_FULL_07   EXPORT     FULL       DEFINING
SYS_EXPORT_FULL_08   EXPORT     FULL       DEFINING
SYS_EXPORT_FULL_09   EXPORT     FULL       DEFINING
SYS_EXPORT_FULL_10   EXPORT     FULL       DEFINING
SYS_EXPORT_FULL_11   EXPORT     FULL       DEFINING
SYS_EXPORT_FULL_12   EXPORT     FULL       DEFINING
SYS_EXPORT_FULL_13   EXPORT     FULL       DEFINING

17 rows selected.


how can I kill all those above jobs, seems like they cancelled export jobs while running.

how to remove all these jobs.
Regards
Sivakumar.A
www.sivakumardba.com
sivakumarocp
Advisor
 
Posts: 256
Joined: Sat Jun 27, 2009 3:53 am
Location: India

Re: Need to remove datapump jobs

Postby Tim... » Fri May 04, 2012 8:06 am

Hi.

Drop them using the dbms_schedueler.drop_job procedure. You can see and example of this here.

http://www.oracle-base.com/articles/10g/scheduler-10g.php#jobs

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17937
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK


Return to Oracle Database Administration

Who is online

Users browsing this forum: No registered users and 9 guests

cron