DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Database Jobs - How to do it

  1. #1
    Join Date
    Oct 2000
    Posts
    2

    Cool

    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!

  2. #2
    Join Date
    Oct 2000
    Posts
    6
    how about DBMS_PIPE?

  3. #3
    Join Date
    Jul 2000
    Posts
    296
    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.

  4. #4
    Join Date
    Oct 2000
    Posts
    123

    Smile

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width