创建JOB
每天晚上11点启动一次JOB,执行存储过程sp_job
Variable jobid number;
Begin
Sys.dbms_job.submit(:jobid,'sp_job;',trunc(sysdate+1)+11/24),
'trunc(sysdate+1)+1/24')
Commit;
End;每天晚上不是trunc(sysdate)+11/24吗?为什么还要+1呢?~~~~高手帮忙解解疑惑~
每天晚上11点启动一次JOB,执行存储过程sp_job
Variable jobid number;
Begin
Sys.dbms_job.submit(:jobid,'sp_job;',trunc(sysdate+1)+11/24),
'trunc(sysdate+1)+1/24')
Commit;
End;每天晚上不是trunc(sysdate)+11/24吗?为什么还要+1呢?~~~~高手帮忙解解疑惑~
Variable jobid number;
Begin
Sys.dbms_job.submit(:jobid,'sp_job;',trunc(sysdate)+23/24),
'trunc(sysdate+1)+23/24')
Commit;
End;
Variable jobid number;
Begin
Sys.dbms_job.submit(:jobid,'sp_job;',trunc(sysdate)+23/24),
'trunc(sysdate)+1+23/24')
Commit;
End;