All pastes #219735 Raw Edit

Stuff

public text v1 · immutable
#219735 ·published 2006-10-24 20:54 UTC
rendered paste body
BEGIN
DBMS_SCHEDULER.CREATE_JOB(
   job_name          =>  'test1',
   job_type          =>  'PLSQL_BLOCK',
   job_action        =>  'INSERT INTO test VALUES(SYSDATE);',
   start_date        =>   to_date('24-OCT-06 16:50:00','DD-MON-YY HH24:MI:SS'),
   repeat_interval   =>   NULL);
END;
/