Database Jobs - How to do it

[boris.klug]

Hi!

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?

Thank you in advance!

[Mok Lo]

how about DBMS_PIPE?

[akkerend]

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.

[mber]

Yes, using DBMS_PIPE is one of the method.
U can write a package which include some procedures or
functions that can be used all the time.

Somthing like:
turn_pipe_on;
turn_pipe_off;
put_line_proc();
get_line_proc();

By using DBMS_PIPE does impact the performance, so use it
carefully.