2 Replies Latest reply: Jun 11, 2014 3:49 AM by Jr.raj RSS

    DBMS_SCHEDULER job not running

    Jr.raj

      Hi oracle gurus

       

      i created a  scheduler job to GATHER_STATS. but its not running.

       

      BEGIN

      DBMS_SCHEDULER.CREATE_JOB (

         job_name             => 'GATHER_SCHEMA_STATS',

         job_type             => 'PLSQL_BLOCK',

         job_action           => 'BEGIN

                                     DBMS_STATS.GATHER_SCHEMA_STATS(''RING_TEST'');

                                     

                            END;',

         start_date           => '11-JUL-2014 04.28.00AM AMERICA/New_York',

         repeat_interval      => 'FREQ=WEEKLY',

         enabled              =>  TRUE,

         comments             => 'Gather schema statistics');

      END;

      /

      i could run this job manually, but its not starting at all, nothing is there in alert log also.

       

      Thanks in advance

       

      Regards

      raj