JOB的建立

begin
  sys.dbms_job.submit(job => :job,
                      what => 'BKG_MISC.AUTO_BACKUP_BOOK(''DGA'',''DGCT'',4,24*7);',
                      next_date => to_date('05-06-2009 14:58:37', 'dd-mm-yyyy hh24:mi:ss'),
                      interval => 'sysdate+1/(24*60)');
  commit;
end;
/

 

直接在PL/SQL DEVELOPER上也可以建立