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