Crear JOB en Oracle

Este código crea un JOB en Oracle que se ejecuta cada 1 hora

BEGIN
DBMS_JOB.isubmit (
job => 99,
what => 'procedimiento(''soy un parametro'');',
next_date => SYSDATE,
interval => 'SYSDATE + 1/24 /* 1 Hour */');

COMMIT;
END;

This entry was posted on sábado, abril 16th, 2011 at 18:18 and is filed under Base de Datos, Desarrollo, Oracle. You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.

Comments are closed.