title: My DBMS_SCHEDULER.CREATE_JOB not running?
body: <p>I am creating a job in oracle 11g express and it is not updating values with the executed job every 5 minutes, and when I check with this to see how many jobs are running, I get 0:</p>
  
  <pre><code>select count(*) from dba_jobs_running;
  </code></pre>
  
  <p>I tried using a commit but didn't work either. This is my query:</p>
  
  <pre><code> CREATE TABLE Individuo
  (
    id_ind int primary key,
    nom_ind Varchar(255),
    ape_ind Varchar(255),
    sal_ind int
  )
  
  DROP table Individuo;
  
  insert into Individuo values(1, 'Carlos', 'Guzman', 100);
  insert into Individuo values(2, 'Hidalgo', 'Machado', 200);
  insert into Individuo values(3, 'Guillermo', 'Pinto', 500);
  insert into Individuo values(4, 'Katia', 'Barba', 300);
  insert into Individuo values(5, 'Fernando', 'Parra', 500);
  insert into Individuo values(6, 'Celesta', 'Valdes', 100);
  insert into Individuo values(7, 'Carola', 'Vallez', 700);
  insert into Individuo values(8, 'Catalina', 'Riveron', 800);
  insert into Individuo values(9, 'Pepe', 'Najarro', 400);
  insert into Individuo values(10, 'Paz', 'Cuenca', 200);
  
  BEGIN
  DBMS_SCHEDULER.CREATE_JOB 
  (
     job_name             =&gt; 'MI_TRABAJO',
     job_type             =&gt; 'PLSQL_BLOCK',
     job_action           =&gt; 'UPDATE Individuo SET sal_ind = sal_ind+1 where id_ind = "8";',
     start_date           =&gt;  SYSDATE,
     repeat_interval      =&gt; 'FREQ=MINUTELY', 
     comments             =&gt; 'La insercion en la tabla Individuo tuvo exito'
  );
  END;
  
  select * from Individuo;
  
  BEGIN
    DBMS_SCHEDULER.ENABLE('MI_TRABAJO');
  END;
  
  BEGIN
    DBMS_SCHEDULER.RUN_JOB('MI_TRABAJO', True);
  END;
  
  SELECT * FROM dba_scheduler_jobs WHERE job_name = 'MI_TRABAJO';
  
  SELECT * FROM dba_scheduler_jobs WHERE job_name = 'MI_TRABAJO'; 
  
  EXEC DBMS_SCHEDULER.DROP_JOB('MI_TRABAJO'); 
  
  commit;
  
  select count(*) from dba_jobs_running;
  </code></pre>