Oracle AQ Question

I'm pretty new to AQ and, dispite reading the manuals and Tom K's blog, I'm
pretty sure that I'm missing something fundamental.

I've got Oracle 10.2.0.4 on a Windows box with two databases, A & B.
Database A is my source.  I have a multi-consumer queue that I'm enqueuing
into.  On database B, my target, I have 5 schemata, each with their own
queue.

On database A I've added each of the B schemata as a subscriber, created a
database link to each of the database B schemata, and added a propagation
schedule for each destination.

I have a working proc to enqueue the data in database A and a proc to
dequeue it in database B that compiles with no errors.  Enqueuing the data
causes rows to appear in the queue table.  Dequeuing them in database B does
not cause any rows to be removed from the queue table in A or any rows to
appear in the queue tables in B.

Querying DBA-JOBS in database A shows five jobs, corresponding to the five
queue schedules.  While the TOTAL_TIME keeps incrementing, the THIS_DATE and
NEXT_DATE data remains unchanged and the LAST_DATE is blank.  E.g.,
LAST_DATE TO_CHAR(THIS_DATE, TO_CHAR(NEXT_DATE, TOTAL_TIME B   FAILURES
--------- ------------------ ------------------ ---------- - ----------
          10-MAR-10 13:36:35 10-MAR-10 13:36:35       1798 N
          10-MAR-10 13:36:35 10-MAR-10 13:36:35       1798 N
          10-MAR-10 13:36:35 10-MAR-10 13:36:35       1798 N
          10-MAR-10 13:36:35 10-MAR-10 13:36:35       1798 N
          10-MAR-10 13:36:35 10-MAR-10 13:36:35       1798 N

They say that they're not broken and have no failures, but they don't appear
to be doing anything.

Querying DBA_QUEUE_SCHEDULES shows 5 schedules with start_date and
current_start_date matching the data in DBA_JOBS.  NEXT_TIME, NEXT_RUN_DATE,
and LAST_RUN_DATE are blank.  It reports 0 FAILURES and nothing in
LAST_ERROR_MSG.

Is this running at all?  What piece am I missing?

Other related posts: