GATHER_STATS_JOB not created in fresh 11g install
I have a 11.1.0.7.0 Database which i am preparing to become a live environment. I have come across a problem in relation to GATHER_STATS_JOB, ie, it does not appear to have been created.
Connected as sys, I run the following:
SQL> select job_name
2 from dba_scheduler_jobs
3 where job_name like 'GATHER_STATS%';
no rows selected
And when I try to enable:
SQL> begin
2 dbms_scheduler.enable('GATHER_STATS_JOB');
3 END;
4 /
begin
*
ERROR at line 1:
ORA-27476: "SYS.GATHER_STATS_JOB" does not exist
ORA-06512: at "SYS.DBMS_ISCHED", line 3417
ORA-06512: at "SYS.DBMS_SCHEDULER", line 2461
ORA-06512: at line 2
I wonder if anyone can tell me or give an indication:
-Why would GATHER_STATS_JOB not be created?
-Is there anyway I can manually create it?
-If this job has failed to create, is there anyway I can check if there are other key jobs that have not been created?
It is my understanding that GATHER_STATS_JOB is an Oracle created job so I am obviously concerned about it not being present.
Any help gratefully accepted.
Regards
Alan