This forum is currently locked. You can't register or post questions at this time. (read more)

Need to remove datapump jobs

All posts relating to Oracle database administration.

Moderator: Tim...

sivakumarocp
Advisor
Posts: 260
Joined: Sat Jun 27, 2009 3:53 am
Location: India

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

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

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


Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 4 guests

cron