paul, no luck select owner,job_name from dba_scheduler_jobs where job_name='GATHER_STATS_JOB'; no rows selected On Fri, Nov 19, 2010 at 8:58 AM, <paul.baumgartel@xxxxxxx> wrote: > Try querying without specifying the owner, just as a sanity check. > > select owner,job_name from dba_scheduler_jobs where > job_name='GATHER_STATS_JOB'; > > > *Paul Baumgartel* > UBS AG > IB Accounting Solutions > 400 Atlantic Street > Stamford, CT 06904 > > 203.719.4368 > > paul.baumgartel@xxxxxxx > www.ubs.com > > > ------------------------------ > *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto: > oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *dd yakkali > *Sent:* Thursday, November 18, 2010 9:32 PM > *To:* oracle-l@xxxxxxxxxxxxx > *Subject:* Scheduler Job not listed in dba_scheduler_jobs > > 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 > > > > Visit our website at http://www.ubs.com > > This message contains confidential information and is intended only > for the individual named. If you are not the named addressee you > should not disseminate, distribute or copy this e-mail. Please > notify the sender immediately by e-mail if you have received this > e-mail by mistake and delete this e-mail from your system. > > E-mails are not encrypted and cannot be guaranteed to be secure or > error-free as information could be intercepted, corrupted, lost, > destroyed, arrive late or incomplete, or contain viruses. The sender > therefore does not accept liability for any errors or omissions in the > contents of this message which arise as a result of e-mail transmission. > If verification is required please request a hard-copy version. This > message is provided for informational purposes and should not be > construed as a solicitation or offer to buy or sell any securities > or related financial instruments. > > > UBS reserves the right to retain all messages. Messages are protected > and accessed only in legally justified cases. >