DBMS_SCHEDULER.STOP_JOB
Hi there,
BEGIN
DBMS_SCHEDULER.STOP_JOB(JOB_NAME => 'BULK_GATHER_V3_JOB', FORCE => TRUE); -- if the job is running then DISABLE
END;
/
SELECT * FROM USER_SCHEDULER_RUNNING_JOBS;
BULK_GATHER_V3_JOB NULL REGULAR FALSE NULL Instance NULL 0 9:23:43.707637 CPU NULL
That is, the job is running without SESSION_ID, RUNNING_INSTANCE, CPU_USED, etc. information.
BEGIN
DBMS_SCHEDULER.STOP_JOB(JOB_NAME => 'BULK_GATHER_V3_JOB'); -- if the job is running then DISABLE
END;
/
Error report:
ORA-27366: job "CMPM.BULK_GATHER_V3_JOB" is not running
ORA-06512: at "SYS.DBMS_ISCHED", line 168
ORA-06512: at "SYS.DBMS_SCHEDULER", line 515
...
BEGIN
DBMS_SCHEDULER.DISABLE(NAME => 'BULK_GATHER_V3_JOB');
END;
/
-- Gives error Job is running.
There is no any massive or big redo undo (DML) operation in the package.
It took 2-3 hours till I was able to stop the job.
My question is: Am I waiting for another DML commit (rollback), which are not part of my job?
Oracle 11.1.0.7 EE
Thank you.