[10g] DBMS_SCHEDULER.stop_job
Bonjour à tous ,
RDMS 10.1.0.2 sur HP UX PA RISC
J'ssaye de supprimer un job :
Code:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
| SQL> SELECT job_name, enabled FROM user_scheduler_jobs;
JOB_NAME ENABL
------------------------------ -----
DATAPUMP_JOB FALSE
SQL> BEGIN
2 DBMS_SCHEDULER.stop_job (job_name => ('"DATAPUMP_JOB"'));
3 end ;
4 /
BEGIN
*
ERROR at line 1:
ORA-03001: unimplemented feature
ORA-06512: at "SYS.DBMS_ISCHED", line 162
ORA-06512: at "SYS.DBMS_SCHEDULER", line 398
ORA-06512: at line 2 |
J'essaye avec le paramétre FORCE :
Code:
1 2 3 4 5 6 7 8 9 10 11 12
| SQL> BEGIN
2 DBMS_SCHEDULER.stop_job (job_name => ('"DATAPUMP_JOB"'),
3 FORCE=>true);
4 end ;
5 /
BEGIN
*
ERROR at line 1:
ORA-03001: unimplemented feature
ORA-06512: at "SYS.DBMS_ISCHED", line 162
ORA-06512: at "SYS.DBMS_SCHEDULER", line 398
ORA-06512: at line 2 |
Quelqu'un a t'il déja eu ce probléme ?
Jaouad