ORACLE(DATE)

select to_date('2010-12-12 12:56:30', 'yyyy-mm-dd HH:mi:ss') from dual;

drop table zhoujiabin_table;
drop procedure proc_zhoujiabin;

--创建表
create table zhoujiabin_table(a char(10));

--创建存储过程
create or replace procedure proc_zhoujiabin
is
begin
insert into zhoujiabin_table values('zhou');
commit;
end;
/

--创建job
declare
job2 number;
begin
dbms_job.submit(job2,'proc_zhoujiabin;',sysdate+8/24/60/60,'sysdate+10/24/60/60');
commit;
end;
/

commit;
show parameter job_queue_processes
该参数必须大于0