How to disable 10g Gather_stats_Job

exec dbms_scheduler.ENABLE(NAME => 'SYS.GATHER_STATS_JOB');

To check the status of the jobs in dba_scheduler_jobs:

SQL> select JOB_NAME,STATE,ENABLED from dba_scheduler_jobs;




JOB_NAME                                      STATE               ENABL

------------------------------         ---------------         -----

AUTO_SPACE_ADVISOR_JOB       SCHEDULED   TRUE

GATHER_STATS_JOB                          DISABLED   FALSE

FGR$AUTOPURGE_JOB                    DISABLED      FALSE

PURGE_LOG                                     SCHEDULED     TRUE

MGMT_CONFIG_JOB                     SCHEDULED      TRUE

MGMT_STATS_CONFIG_JOB         SCHEDULED     TRUE



6 rows selected.