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; /