create table tj(time1 date,time2 date)
/
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;
/
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;
1 2011-9-13 11:17:28 2011-9-13 11:17:34
2 2011-9-13 11:17:38 2011-9-13 11:17:44
3 2011-9-13 11:17:48 2011-9-13 11:17:54
4 2011-9-13 11:17:58 2011-9-13 11:18:04
11 2011-9-13 11:18:08 2011-9-13 11:18:14
5 2011-9-13 11:18:18 2011-9-13 11:18:24
6 2011-9-13 11:18:28 2011-9-13 11:18:34
7 2011-9-13 11:18:38 2011-9-13 11:18:44
8 2011-9-13 11:18:48 2011-9-13 11:18:54
9 2011-9-13 11:18:58 2011-9-13 11:19:04
10 2011-9-13 11:19:08 2011-9-13 11:19:14
12 2011-9-13 11:19:18 2011-9-13 11:19:24
2 2011-9-13 11:17:38 2011-9-13 11:17:44
3 2011-9-13 11:17:48 2011-9-13 11:17:54
4 2011-9-13 11:17:58 2011-9-13 11:18:04
11 2011-9-13 11:18:08 2011-9-13 11:18:14
5 2011-9-13 11:18:18 2011-9-13 11:18:24
6 2011-9-13 11:18:28 2011-9-13 11:18:34
7 2011-9-13 11:18:38 2011-9-13 11:18:44
8 2011-9-13 11:18:48 2011-9-13 11:18:54
9 2011-9-13 11:18:58 2011-9-13 11:19:04
10 2011-9-13 11:19:08 2011-9-13 11:19:14
12 2011-9-13 11:19:18 2011-9-13 11:19:24
job执行时间比调度时间长,则会再加一次调度间隔时间去执行
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25323853/viewspace-707238/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/25323853/viewspace-707238/