Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DBMS_SCHEDULER.STOP_JOB

konstantin.gudjevApr 26 2012 — edited Apr 28 2012
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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 26 2012
Added on Apr 26 2012
1 comment
1,473 views