we have to do asynchronious database job: One process puts messages
in a queue and other processes get the msgs and do the real work.
I think the dmbs_aq package is great for doing things with queues (maybe thats why the packages is named "advance queuing" :-)).
But how to I start "jobs" in the meaning of processes that just wait for an signal/msg to execute? With dbms_jobs? Or with triggers? What is the standard way to do it?
The package DBMS_AQADM is an interface to the administrative tasks of Advanced Queuing, such as creating/dropping queues and queue tables.
The package DBMS_AQ offers accesss to the enqueue en dequeue operations.