Re: How to kill jobs in "select * from DBA_DATAPUMP_JOBS"

On Sep 5, 11:43 am, Big George <jbet..._at_gmail.com> wrote:
> Hello
>
> I am trying to kill the jobs that I see on DBA_DATAPUMP_JOBS (Oracle
> 10g R1)
>
> select * from DBA_DATAPUMP_JOBS
>
> OWNER_NAME      JOB_NAME        OPERATION       JOB_MODE        STATE   DEGREE  ATTACHED_SESSIONS
>
> SYS     PHR_EXPORT2     EXPORT TABLE NOT RUNNING        0       0
> SYS     PHR_EXPORT      EXPORT TABLE NOT RUNNING        0       0
> SYS     PHR_EXPORT1     EXPORT TABLE NOT RUNNING        0       0
>
> I made those one connected as sys user.
> Now, I can't kill them.
> I try to get the prompt Export>kill_job, but I'm not able.
>
> c:\expdp sys/passwordOfSys_at_servicename attach=PHR_EXPORT
>
> Oracle asks me Username:, and I put system. After that:
>
> Connected to: Oracle Database 10g Release 10.1.0.4.0 - Production
> ORA-31626: job does not exist
> ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
> ORA-06512: at "SYS.KUPV$FT", line 330
> ORA-31638: cannot attach to job PHR_EXPORT for user SYSTEM
> ORA-31632: master table "SYSTEM.PHR_EXPORT" not found, invalid, or
> inaccessible
> ORA-00942: table or view does not exist
>
> Is it any way to kill or delete the jobs showed in DBA_DATAPUMP_JOBS?
>
> Thanks !

Most likely they're created by DBMS_SCHEDULER, and you should try using that package to disable the jobs:

exec dbms_scheduler.disable('PHR_EXPORT2')
exec dbms_scheduler.disable('PHR_EXPORT')
exec dbms_scheduler.disable('PHR_EXPORT1')

or drop them entirely:

exec dbms_scheduler.drop_job('PHR_EXPORT2')
exec dbms_scheduler.drop_job('PHR_EXPORT')
exec dbms_scheduler.drop_job('PHR_EXPORT1')

David Fitzjarrell Received on Fri Sep 05 2008 - 12:52:26 CDT