bz_prp_schedules.sql

来自「oracle9i+j2ee开发aq oracle9i+j2ee开发aq or」· SQL 代码 · 共 51 行

REM script name: bz_prp_schedules.sql
REM This script adds schedules to propagate messages
REM propagation
REM version: 9i

REM =======================================================
REM cleanup section
REM =======================================================

REM null destination defaults to local database1
execute dbms_aqadm.unschedule_propagation(queue_name => 'bzcardorders_q');

execute dbms_aqadm.unschedule_propagation(queue_name => 'bzcardorders_q', -
		destination => 'loopback');

REM =======================================================
REM Add a propagation schedule to the local database
REM =======================================================

execute dbms_aqadm.schedule_propagation( -
	queue_name => 'bzcardorders_q', -
	destination => 'local');
	
REM =======================================================
REM Add a propagation schedule to the remote database
REM =======================================================

execute dbms_aqadm.schedule_propagation( -
	queue_name => 'bzcardorders_q', -
	destination => 'loopback');

REM =======================================================
REM Add a propagation schedule for an hour every mid-night
REM =======================================================

execute dbms_aqadm.schedule_propagation( -
	queue_name => 'bzcardorders_q', -
	destination => 'loopback', -
	start_time => TO_DATE(sysdate, 'DD-MM-RR'), -
	duration => 7200);

REM =======================================================
REM Add a propagation schedule that continually propagates messages and
REM checks after 5 seconds for more messages to be propagated
REM =======================================================

execute dbms_aqadm.schedule_propagation( -
	queue_name => 'bzcardorders_q', -
	destination => 'loopback', -
	latency	=> 5);