Enable GATHER_STATS_JOB:
SQL> exec dbms_scheduler.enable(‘GATHER_STATS_JOB’); PL/SQL procedure successfully completed.
Check job status:
SQL> select job_name, enabled from DBA_SCHEDULER_JOBS WHERE job_name = ‘GATHER_STATS_JOB’;
Disable GATHER_STATS_JOB:
SQL> exec dbms_scheduler.disable(‘GATHER_STATS_JOB’); PL/SQL procedure successfully completed.
Check job status:
SQL> select job_name, enabled from DBA_SCHEDULER_JOBS WHERE job_name = ‘GATHER_STATS_JOB’;
You can run the job manually via DBMS_SCHEDULER:
BEGIN DBMS_SCHEDULER.RUN_JOB( job_name => 'GATHER_STATS_JOB' ); END; /
References: