CREATE OR REPLACE PROCEDURE TempInsert1 AS
BEGIN
  INSERT INTO temp_table1 (num_col, char_col)
    VALUES (temp_seq.NEXTVAL,
            TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'));
  COMMIT;
END TempInsert1;
/

declare
    my_job number;
  begin
    dbms_job.submit(job=>my_job, what=>'TempInsert1;',next_date=>sysdate,interval=>'sysdate+1/86400');
    DBMS_OUTPUT.PUT_LINE('my_job='||my_job);
  end;

 select NEXT_DATE, NEXT_SEC, BROKEN, FAILURES, WHAT from USER_JOBS where JOB=913870
NEXT_DATE             NEXT_SEC BROKEN FAILURES WHAT                             
--------------------- -------- ------ -------- ---------------------------------
3/12/2009 4:49:53 AM  04:49:53 N               TempInsert;                      
1 row selected