2 Replies Latest reply: Jul 11, 2013 1:40 AM by Marwim RSS

    How to run jobs in oracle 10g

    18d33c3f-5a79-4fa0-b366-ca9aa08e8d57

      I have created the following job,

       

       

      BEGIN

      -- Job defined entirely by the CREATE JOB procedure.

      DBMS_SCHEDULER.create_job (

      job_name => 'Update_Status',

      job_type => 'PLSQL_BLOCK',

      job_action => 'BEGIN ;updateStatus; END;',

      start_date => SYSTIMESTAMP,

      repeat_interval => 'freq=minutely; bysecond=0;',

      end_date => NULL,

      enabled => TRUE,

      auto_drop => FALSE,

      comments => 'Job defined entirely by the CREATE JOB procedure.');

      end;

       

      When I look for the status of the job in the following table

      SELECT *FROM USER_SCHEDULER_JOB_LOG

       

      The Status field shows Failed. How to make my job runnable what could be reason. Please help to solve this problem.