Scheduler Job not listed in dba_scheduler_jobs

  • From: dd yakkali <dd.yakkali@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 18 Nov 2010 18:31:51 -0800

Fellow DBAs,

Database version: 11.1.0.7

I tried to create a scheduler job and I get an error that the job already
exists. When I query the dba_scheduler_jobs view I do not see that job. Am I
missing something here?

begin
dbms_scheduler.create_schedule(
    schedule_name => 'STATS_COLLECTION',
    repeat_interval => 'FREQ=daily;byhour=06;byminute=00;bysecond=00',
    comments => 'Schedule to collect statistics');
DBMS_SCHEDULER.CREATE_JOB (
    job_name => 'GATHER_STATS_JOB',
    job_type => 'STORED_PROCEDURE',
    job_action => 'DBMS_STATS.GATHER_DATABASE_STATS_JOB_PROC',
    schedule_name => 'STATS_COLLECTION',
    enabled => TRUE);
end;
/
  2    3    4    5    6    7    8    9   10   11   12   13  begin
*
ERROR at line 1:
ORA-27477: "SYS.GATHER_STATS_JOB" already exists
ORA-06512: at "SYS.DBMS_ISCHED", line 99
ORA-06512: at "SYS.DBMS_SCHEDULER", line 355
ORA-06512: at line 6

DBA_SCHEDULER_JOBS:

select owner,job_name from dba_scheduler_jobs where owner='SYS' and
job_name='GATHER_STATS_JOB';
no rows selected

dba_scheduler_job_log:

select log_date,JOB_NAME, STATUS FROM  dba_scheduler_job_log WHERE
JOB_NAME='GATHER_STATS_JOB' AND OWNER='SYS';
no rows selected


DBA_OBJECTS:

select object_name, object_type from dba_objects where owner='SYS' AND
OBJECT_NAME='GATHER_STATS_JOB';
OBJECT_NAME                                    OBJECT_TYPE
-----------------------------------
-----------------------------
GATHER_STATS_JOB                           JOB


DBA_JOBS:
SELECT WHAT, LOG_USER FROM DBA_JOBS WHERE log_user='SYS';

WHAT                      LOG_USER
------------------------- ------------------------------
admin.clean_db_logons;    SYS

Thanks
Deen

Other related posts: