Oracle中创建定时job

点击(此处)折叠或打开
					
				
				
					create procedure refresh_mv as
cursor c is select table_name from user_tables where table_name like '%MV%';

begin
for i in c loop
dbms_mview.refresh(i.table_name);
end loop;
end;
/
				
			

			
				
					
						点击(此处)折叠或打开
					
				
				
					BEGIN
DBMS_SCHEDULER.CREATE_JOB (
job_name => 'myjob',
job_type => 'STORED_PROCEDURE',
job_action => 'refresh_mv',
start_date => sysdate,
repeat_interval => 'FREQ=HOURLY;INTERVAL=12');
END;
/
exec dbms_scheduler.enable('myjob');
exec dbms_scheduler.set_attribute(name=>'myjob',attribute=>'repeat_interval',value=>'FREQ=HOURLY;INTERVAL=3');

关于repeat_interval的设置可以参考 http://leo1211.iteye.com/blog/1069473