title: Using dbms_scheduler to run a program
body: <p>I am trying to run a program using scheduler job.My code goes as follows:</p>
  
  <pre><code>--Program
  BEGIN
    dbms_scheduler.create_program (
      program_name    =&gt;  'firstprogram',
      program_type    =&gt;  'PLSQL_BLOCK',
      program_action  =&gt;  'BEGIN Execute immediate ''Create table xyz(id int, name varchar2(10))''; end;',
      enabled         =&gt;  TRUE,
      comments        =&gt;  'First program');
  
  END;
  /
  --Schedule
  BEGIN
    DBMS_SCHEDULER.create_schedule (
      schedule_name   =&gt; 'firstschedule',
      start_date      =&gt; SYSTIMESTAMP,
      repeat_interval =&gt; 'freq=daily; byhour=14; byminute=25',
      end_date        =&gt; NULL,
      comments        =&gt; 'Repeats daily');
  END;
  /
  --Job
  BEGIN
    dbms_scheduler.create_job (
      job_name      =&gt;  'firstjob',
      program_name  =&gt;  'firstprogram',
      schedule_name =&gt;  'firstschedule',
      enabled       =&gt;  TRUE,
      comments      =&gt;  'Use firstprogram and FirstSchedule');
  END;
  /
  </code></pre>
  
  <p>All these code blocks compile without showing any errors. But the table <code>xyz</code> is not created in the specified time. Can anyone explain me why? I am using Oracle.</p>