dbms_scheduler

Hi,

Please suggest if below code looks fine and if it will run every 3 hours. Any other better option.

BEGIN

dbms_scheduler.create_job('"GATHER_LKJ_STAT"',

job_type=>'PLSQL_BLOCK', job_action=>

'BEGIN DBMS_STATS.GATHER_SCHEMA_STATS (OWNNAME=>''EASTJM'', ESTIMATE_PERCE

NT=>0.0001, OPTIONS=>''GATHER STALE''); DBMS_STATS.GATHER_SCHEMA_STATS (OWNNAME=

>USER, ESTIMATE_PERCENT=>0.0001, OPTIONS=>''GATHER EMPTY''); END;'

, number_of_arguments=>0,

start_date=>TO_TIMESTAMP_TZ('18-FEB-2012 10.37.15.000000000 AM -04:00','DD-MON-R

RRR HH.MI.SSXFF AM TZR','NLS_DATE_LANGUAGE=english'), repeat_interval=>

'freq=daily; byhour=3; BYMINUTE=00'

, end_date=>NULL,

job_class=>'"CKP12"', enabled=>FALSE, auto_drop=>TRUE,comments=>