创建JOBS的SQL语句为:
begin
sys.dbms_job.submit(job => :job,
what => 'student_bak_proc;',
next_date => to_date('10-04-2009 09:21:48', 'dd-mm-yyyy hh24:mi:ss'),
interval => 'sysdate+1/288');
commit;
end;
/创建存储过程的SQL为:
create or replace PROCEDURE student_bak_proc as
begin
insert into student_bak (SELECT * FROM student ) ;
END;
我的目的是过一段五分钟就执行一次把student表中的数据插入到student_bak表中!
可是执行了,在student_bak表中没有数据啊?
begin
sys.dbms_job.submit(job => :job,
what => 'student_bak_proc;',
next_date => to_date('10-04-2009 09:21:48', 'dd-mm-yyyy hh24:mi:ss'),
interval => 'sysdate+1/288');
commit;
end;
/创建存储过程的SQL为:
create or replace PROCEDURE student_bak_proc as
begin
insert into student_bak (SELECT * FROM student ) ;
END;
我的目的是过一段五分钟就执行一次把student表中的数据插入到student_bak表中!
可是执行了,在student_bak表中没有数据啊?
查询看看有数据吗
begin
insert into student_bak (SELECT * FROM student ) ;
commit;
END;
在PL/SQL里编辑完成后直接点击“应用”就执行了吧?!还是需要再怎么弄让这JOB执行啊?
begin
insert into student_bak select * from student;
end;
/==============================================================================
begin
sys.dbms_job.submit(job => :job,
what => 'student_bak_proc;',
next_date => trunc(sysdate)+(5*60)/3600/24,
interval => 'trunc(sysdate)+(5*60)/3600/24');
commit;
end;
/
试试这个