Database Software

HI All,

I have many, many jobs in dbs_scheduler_jobs table:

SQL> select count(*),owner,  enabled from dba_scheduler_jobs group by enabled, owner;

        24

SYS

FALSE

         6

SCDAT

FALSE

      4050

SCDAT

TRUE

I tried to remove them like this:

exec DBMS_SCHEDULER.drop_job (job_name => 'SCDAT.JOB_AOC_181', force=>TRUE);

But I got an error like below:

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

All 4050 jobs under user SCDAT have the same job_name:

SQL> select job_name, owner, count(*) from dba_scheduler_jobs where owner = 'SCDAT' group by job_name, owner ;

JOB_AOC_181

SCDAT

      4050

Does anyone know how to remove those jobs??

Thanks