日期:2014-05-16 浏览次数:20406 次
create or replace procedure test_job ( in_jobname in varchar2 , out_jobno out number ) as jobno number; begin SYS.DBMS_JOB.SUBMIT ( job => jobno ,what => in_jobname ,next_date => to_date('02-07-2008 01:00:00','dd/mm/yyyy hh24:mi:ss') ,interval => 'trunc(sysdate+1)+(1/24)' ,no_parse => FALSE ); sys.dbms_output.put_line('Job Number is: ' || to_char(jobno)); out_jobno :=jobno; commit; end test_job;?