Managing the Propagation Job
Enabling and Disabling the Propagation
Job
By default the propagation jobs are enabled
when propagation is created. If a propagation job is disabled
for any specific reason and subsequently it needs to be enabled,
the enable_propagation_schedule procedure in the
dbms_aqadm package can be used to enable it.
For example, to enable a propagation job
that propagates events from the NY4_QUEUE source queue using the
DNYOIP20.world database link, the following SQL block should be
run:
BEGIN
DBMS_AQADM.ENABLE_PROPAGATION_SCHEDULE(
queue_name => 'strmadm.NY4_QUEUE',
destination => 'DNYOIP20.world');
END;
/
To disable the propagation job that stops
the event propagation, use the following SQL block:
BEGIN
DBMS_AQADM.DISABLE_PROPAGATION_SCHEDULE(
queue_name => 'strmadm.NY4_QUEUE',
destination => 'DNYOIP20.world');
END;
/
