How to kill jobs in "select * from DBA_DATAPUMP_JOBS"

[Big George]

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@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 !

[ora...@msn.com]

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

[The Boss]

You are mixing 'SYS' and 'SYSTEM'.

HTH

--
Jeroen