oracle 定时器



 无输出参数:

 declare
    jobno number;
  begin
    dbms_job.submit(
      jobno,
      what => 'sp_alert_info;',                      -- sp_dayend为存储过程的名称
      --Interval => 'TRUNC(sysdate) + 1 + 17/(24)'   -- 定义时间间隔
     Interval => 'TRUNC(sysdate,''mi'') + 10/(24*60)'
    );
    commit;
  end;

有输出参数:

  declare
    jobno NUMBER;
  begin
    dbms_job.submit(
      job  => jobno,
      what => 'declare v_errorcode NUMBER;v_errordesc varchar(200);begin sp_mer_sync(p_workdate => to_char(sysdate,''yyyyMMdd''),
                                      p_errorcode => v_errorcode,
                                      p_errordesc => v_errordesc)
                          ; end;',                      -- sp_mer_sync为存储过程的名称
      --Interval => 'TRUNC(sysdate) + 1 + 17/(24)'   -- 定义时间间隔
     Interval => ' TRUNC(sysdate+1)  + 05/(24) '
    );
    commit;
  end;

查

select job,last_date,last_sec,next_date,next_sec,broken,failures from dba_jobs;