dbms_jobvsOracleScheduler - 数据库编程

SELECT * FROM dba_scheduler_jobs WHERE job_name = 'TEST_FULL_JOB_DEFINITION';
REPEAT_INTERVAL的例子

'FREQ=DAILY; BYDAY=SUN; BYHOUR=18;',
 
'freq=MINUTELY;interval=1',  
 
'freq=MINUTELY;interval=5',  
 
'freq=HOURLY;interval=1',    
 
'FREQ=DAILY; BYDAY=MON,TUE,WED,THU,FRI,SAT,SUN; BYHOUR=22;',

更多关于dbms_scheduler的用法可以常见官方文档

http://docs.oracle.com/cd/E11882_01/server.112/e25494/scheduse.htm#ADMIN13380

参考文档：

http://docs.oracle.com/cd/B10501_01/server.920/a96521/jobq.htm#9499
http://www.mandsconsulting.com/oracle-dbms_scheduler-vs-dbms_job-create-run-monitor-remove
http://docs.oracle.com/cd/E11882_01/server.112/e25494/scheduse.htm#ADMIN13380

dbms_jobvsOracleScheduler(二)