-- ------------------------------------------------------------
-- 提交任务从6:00开始,每小时运行一次
-- ------------------------------------------------------------
dbms_job.submit(
jobno, 'statspack.snap;',
trunc(sysdate)+6/24,
'trunc(SYSDATE+1/24,''HH'')',
TRUE,
instno);
-- ------------------------------------------------------------
-- 提交任务从9:00开始,12小时后运行
-- ------------------------------------------------------------
dbms_job.submit(
jobno,
'statspack.snap;',
trunc(sysdate+1)+9/24,
'trunc(SYSDATE+12/24,''HH'')',
TRUE,
instno);
------------------------------------------------------------
-- 提交任务从6:00开始,每隔十分钟运行一次
-- ------------------------------------------------------------
dbms_job.submit(
jobno,
'statspack.snap;',
trunc(sysdate+1/144,'MI'),
'trunc(sysdate+1/144,''MI'')',
TRUE,
instno);
-- ----------------------------------------------------------------
-- 提交任务从周一到周五早上6:00开始,每小时运行一次
-- ----------------------------------------------------------------
dbms_job.submit(
jobno,
'statspack.snap;',
trunc(sysdate+1)+6/24,
'trunc(
least(
next_day(SYSDATE,''MONDAY''),
next_day(SYSDATE,''TUESDAY''),
next_day(SYSDATE,''WEDNESDAY''),
next_day(SYSDATE,''THURSDAY''),
next_day(SYSDATE,''FRIDAY'')
)
+1/24,''HH'')',
TRUE,
instno);
commit;
end;
-- 提交任务从6:00开始,每小时运行一次
-- ------------------------------------------------------------
dbms_job.submit(
jobno, 'statspack.snap;',
trunc(sysdate)+6/24,
'trunc(SYSDATE+1/24,''HH'')',
TRUE,
instno);
-- ------------------------------------------------------------
-- 提交任务从9:00开始,12小时后运行
-- ------------------------------------------------------------
dbms_job.submit(
jobno,
'statspack.snap;',
trunc(sysdate+1)+9/24,
'trunc(SYSDATE+12/24,''HH'')',
TRUE,
instno);
------------------------------------------------------------
-- 提交任务从6:00开始,每隔十分钟运行一次
-- ------------------------------------------------------------
dbms_job.submit(
jobno,
'statspack.snap;',
trunc(sysdate+1/144,'MI'),
'trunc(sysdate+1/144,''MI'')',
TRUE,
instno);
-- ----------------------------------------------------------------
-- 提交任务从周一到周五早上6:00开始,每小时运行一次
-- ----------------------------------------------------------------
dbms_job.submit(
jobno,
'statspack.snap;',
trunc(sysdate+1)+6/24,
'trunc(
least(
next_day(SYSDATE,''MONDAY''),
next_day(SYSDATE,''TUESDAY''),
next_day(SYSDATE,''WEDNESDAY''),
next_day(SYSDATE,''THURSDAY''),
next_day(SYSDATE,''FRIDAY'')
)
+1/24,''HH'')',
TRUE,
instno);
commit;
end;