/

create or replace procedure PROC_JOB_TEST

as

begin_time date;

end_time date;

begin

select sysdate into begin_time from dual;

dbms_lock.sleep(6);

select sysdate into end_time from dual;

insert into tj(time1,time2)values(begin_time,end_time);

commit;

end;

/

DECLARE jobno number;

BEGIN

DBMS_JOB.SUBMIT(jobno,

'PROC_JOB_TEST;',

sysdate,

'SYSDATE+5/24/60/60');

COMMIT;

END;