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.
As an example
let's
look at
enable_propagation_schedule
used
with
dbms_aqadm.
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
containing
dbms_aqadm:
BEGIN
DBMS_AQADM.DISABLE_PROPAGATION_SCHEDULE(
queue_name
=>
'strmadm.NY4_QUEUE',
destination
=>
'DNYOIP20.world');
END;
/
