Scheduler Job not listed in dba_scheduler_jobs

From: dd yakkali <dd.yakkali_at_gmail.com>
Date: Thu, 18 Nov 2010 18:31:51 -0800
Message-ID: <AANLkTikgNFd21TUik7WNrfJwTZTiC3ZshUKmv7e0rBE+_at_mail.gmail.com>

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

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Nov 18 2010 - 20:31:51 CST