declare
job number;//声明
begin
dbms_job.submit(job,what,next_date,interval);
commit;
end;
job:声明的job
what:要执行的SQL语句或过程等
next_date:第一次执行的时间
interval:多久执行一次,null表示不再执行
1.创建表以及插入数据
create table job_test(bir date);
insert into job_test(sysdate);
select * from job_test;
2.创建存储过程
create or replace procedure job_test_jobproce as
begin
insert into job_test values(sysdate);
end job_test_jobproce;
3.创建job,默认自动执行
declare
job_test_job number;
begin
dbms_job.submit(job_test_job,'job_test_proce;',sysdate,'null');
commit;
end;
或者
declare
job_test_job number;
begin
dbms_job.submit(job_test_job,'insert into job_test values(sysdate);',
to_date('2018-10-09 08:38:00','yyyy-mm-dd hh24:mi:ss'),'null');
commit;
end;