hello,
created a Dynamic Scheduler from procedure.
i have multiple job which will run on different days it works fine issue is when i need to stop job which is " not still run" then it is not allowing me to Stop it or drop it or disable it.
Like today is Wednesday and i have a job schedule for Friday then it will not allow me to do so.
error: job_name is not running.
First disable and stop any job which exits :
select count(*) from user_scheduler_jobs
--if exits then disable and stop
DBMS_SCHEDULER.DISABLE(my_job);
DBMS_SCHEDULER.STOP_JOB(my_job);
Drop job :
dbms_scheduler.drop_job(job_name => my_job,
defer => TRUE,
commit_semantics => 'TRANSACTIONAL');
then again create new one with same name. but its like i am not able to get it how to stop Friday's job which is not run yet
do we need to do this ? ? : oracle - Cannot stop/drop job in DBMS_SCHEDULER - Stack Overflow
Message was edited by: Chingari_cigi added a URL with same issue