用DBMS_JOB来实现高级计划任务

dbms_job.submit(

jobno,

'statspack.snap;',

trunc(sysdate+1/144,'MI'),

'trunc(sysdate+1/144,''MI'')',

TRUE,

instno);

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;