Geek Answers Handbook

How to stop or delete a task from Oracle Task Scheduler

Sounds easy, right? I have a job that works, which I would like to stop (it worked for a long way, and there is clearly a problem with it). Well, when I try to stop working, I get this message:

ORA-27366: operation "string.string" not started. Cause. An attempt was made to stop work that was not running.

However, when I try to completely drop the job, because I REALLY do not want it to work anymore, I get this message:

ORA-27478: job running "string.string". Cause. An attempt was made to reset a job that is currently running.

Really, Oracle? Make up your mind! Has anyone seen this before? How can I stop this task without restarting the server?!?!

+4
source share
2 answers

This happened to us before, and we had to abandon the server, very annoying.

+3
source

You can try the following:

DBMS_SCHEDULER.DROP_JOB (JOB_NAME => 'my_jobname');

OR

try also specifying the name of the job. Oracle creates a table for work that is instantly created. Try desc jobname; note the scheme that created the task and added it to the task name in the desc statement.

then you can delete it using the conversion table instructions.

0
source

More articles:


All Articles