如何让一个job每天凌晨两点执行啊？

Question

SQL> declare
  2  jobno number;
  3  begin
  4  dbms_job.submit(jobno,'recompile;',to_date('20060907020000','yyyy-mm-dd hh24:mi:ss'),'trunc(sysdate)+1');
  5  commit;
  6  end;
  7  /PL/SQL procedure successfully completedSQL>

Answer 1

SQL> declare
  2  jobno number;
  3  begin
  4  dbms_job.submit(jobno,'recompile;',to_date('20060907020000','yyyy-mm-dd hh24:mi:ss'),'trunc(sysdate)+26/24');             -- 凌晨2点
  5  commit;
  6  end;
  7  /PL/SQL procedure successfully completedSQL>

Answer 2

variable jobno number;
BEGIN
DBMS_JOB.SUBMIT(:jobno,
                    'procname;',---存储过程名
                    to_date(to_char(sysdate,'yyyymmdd'),'yyyymmdd') + 1/24+1/24,
                    '(to_date(to_char(sysdate,''yyyymmdd''),''yyyymmdd'') + 1/24+1/24) + 1'); 
COMMIT;
END;
/

Answer 3

用pl/sql developer打开你建好的job，直接修改参数就行了

Answer 4

用pl/sql里面有job，在这里设置，直观