17,377
社区成员
发帖
与我相关
我的任务
分享
create table a(a date);
--创建一个自定义过程
create or replace procedure test as
begin
insert into a values(sysdate);
end;
--创建JOB
variable job1 number;
begin
dbms_job.submit(:job1,'test;',sysdate,'sysdate+1/1440');
commit;
end;
--
begin
dbms_job.run(:job1);
end;
test--它要大写
create table a(a date);
create or replace procedure tests as
begin
insert into a values(sysdate);
end tests;
variable job1 number;
begin
dbms_job.submit(:job1,'TESTS;',sysdate,'sysdate+1/1440');--TESTS;要大写
end;
begin
dbms_job.run(:job1);
end;
SQL> select * from a;
A
-------------------
2011-05-25 14:44:18
SQL> select * from a;
A
-------------------
2011-05-25 14:44:18
2011-05-25 14:45:22
SQL> select * from a;
A
-------------------
2011-05-25 14:44:18
2011-05-25 14:45:22
2011-05-25 14:46:23