Attributes to create an event-based job - Oracle DBA

Q.  Which of these additional attributes must be set to create an event-based job?

- Published on 12 Aug 15

a. queue_spec
b. event_condition
c. Both A & B
d. None of the above

ANSWER: Both A & B
 

    Discussion

  • Nirja Shah   -Posted on 21 Aug 15
    - A queue_spec and event_condition are used to create an event-based job
    queue_spec - It is a queue specification which includes the name of the queue where all the messages are enqueued to raise job start events. In case of a secure queue the queue is followed by a comma and the agent name.

    event_condition - It is a conditional expression based on the message properties that must evaluate to TRUE for the message to start the job. The expression must have the syntax of an Oracle Streams Advanced Queuing rule.

Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)