1 Reply Latest reply: Sep 26, 2012 1:52 AM by spajdy RSS

    Checking correct creation for oracle Job

    848638
      Hi,

      I want to know if my job will be executed if not appers nothing in job_action into the dba_scheduler_jobs. Because the job appears but not have information in job_action column.

      The creation is here:

      begin
      dbms_scheduler.create_schedule
      (schedule_name => 'TEST.WEEKLY',
      start_date=> SYSTIMESTAMP,
      repeat_interval=> 'FREQ=WEEKLY; byday=mon,tue,wed,thu,fri; byhour=21; byminute=55; bysecond=0',
      comments=>' Run every day MON-FRI');
      end;
      /



      Program Example



      begin

      -- Call a procedure of a database package
      dbms_scheduler.create_program
      (program_name=> 'TEST.CL_DS_INSERT',
      program_type=> 'STORED_PROCEDURE',
      program_action=> 'TEST.CL_BOUNDS_UTILS.INSERTS',
      enabled=>true,
      comments=>'Procedure TEST.CL_BOUNDS_UTILS.INSERTS.'
      );

      end;

      /


      Job Example

      begin
      --

      dbms_scheduler.create_job
      (job_name => 'TEST.CL_INSERTS',
      program_name=> 'TEST.CL_DS_INSERT',
      schedule_name=>'WEEKLY',
      enabled=>true,
      auto_drop=>false,
      comments=>'Job to INSERT');
      end;
      /



      please give me your comments

      Regards!!