oracle 简单job

 

 

Code
begin
  sys.dbms_job.submit(job => :job,
                      what => 'test;',
                      next_date => to_date('26-02-2009 23:00:00', 'dd-mm-yyyy hh24:mi:ss'),
                      interval => 'trunc(SYSDATE)+23/24');
  commit;
end;

 

 

test 为存储过程名字

转载于:https://www.cnblogs.com/gwazy/archive/2009/02/26/1398836.html