Hi All,
This is my first post, so if I did anything wrong please excuse me.
I'm working under Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production.
My problem is like below:
SQL> select count(*),owner, enabled from dba_scheduler_jobs group by enabled, owner;
24
SYS
FALSE
6
SCDAT
FALSE
4050
SCDAT
TRUE
For the owner SCDAT I have 4050 jobs, that can not be dropped. I tried everything I have found in the oracle forums.
All jobs have exactly the same name: JOB_AOC_181
#1
exec DBMS_SCHEDULER.drop_job (job_name => 'SCDAT.JOB_AOC_181', force=>TRUE);
ERROR at line 1:
ORA-27475: unknown job "SCDAT"."JOB_AOC_181"
ORA-06512: at "SYS.DBMS_ISCHED", line 243
ORA-06512: at "SYS.DBMS_SCHEDULER", line 778
ORA-06512: at line 1
#2
set head off
spool job_disable.sql
select 'execute dbms_scheduler.disable('||''''||owner||'.'||job_name||''''||');' from dba_scheduler_jobs where enabled='TRUE';
spool off;
@job_disable.sql
and many other. I've even disable DBMS_Scheduler_job execution:
ALTER SYSTEM SET job_queue_processes = 0;
EXEC dbms_scheduler.set_scheduler_attribute('SCHEDULER_DISABLED','TRUE');
and then tried to remove jobs, but always I cound't do this.
My DBMS_SCHEDULER is killed by all those jobs.
Please let me know if anyone from you guys know what to do?
Thanks, Tom.