Cheers Nigel,

I had sussed that out to be honest. What I don't understand is how why
you do not see the frequency of the job when querying the scheduler

SELECT start_date,end_date,next_run_date,last_start_date FROM
DBA_SCHEDULER_JOBS WHERE JOB_NAME = 'GATHER_STATS_JOB'

START_DATE END_DATE  NEXT_RUN_DATE     LAST_START_DATE
---------- ---------- -------------------- --------------------
                            04-JUL-06 22.00.00.8
                            56571 +01:00

John

This job is created, and enabled automatically when you create a new
Oracle database under Oracle Database 10g. To see this job, use the
DBA_SCHEDULER_JOBS view

Disable thus:
exec dbms_scheduler.disable('GATHER_STATS_JOB');

See http://www.dbazine.com/olc/olc-articles/freeman2,
http://www.oracle.com/technology/pub/articles/10gdba/week20_10gdba.html,
etc...


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