Re: DBMS_JOB and 'near' real-time

The House Dawg wrote:
> Aren't both AQ and replication built on top of DBMS_JOB? Is there an
> advantage in using the AQ layer of abstraction over the lower level
> DBMS_JOB? The DBMS_JOB package gets called by AQ anyways...
>
> TIA,
>
> Matt

Aren't both AQ and replication built on top of DBMS_JOB?

In a sense but your question appears to assume something, that AQ is an API to jobs, that is not the case.

Is there an advantage in using the AQ layer of abstraction?

Yes. A very substantial one.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)