先定义job
variable job number
然后在执行如下语句
begin
sys.dbms_job.submit(job=>:job,
what=>'get_table_history_stats;',
next_date=>to_date('17-10-2012 06:09:00','dd-mm-yyyy hh24:mi:ss'),
interval=>'sysdate+1');
commit;
end;
[@more@]