强大的scheduler

BEGIN
DBMS_SCHEDULER.CREATE_JOB(
job_name=>'auto_exec_pro_test',
job_type=>'STORED_PROCEDURE',
job_action=>'pro_test',
start_date=>SYSDATE,  repeat_interval=>'FREQ=MONTHLY; BYMONTHDAY=-1,-2,-3,-4,-5; BYHOUR=3',
enabled=>TRUE); 
END;

每月前5天的凌晨3点执行pro_test..........