Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

[Database]Flow for event based job on secure queue

User_EF4YWJul 5 2019

Hi guys

Can you please help me identify what am I missing?

I'm trying to execute a dequeue procedure on arrival of a message(message has recipients) in a particular queue

Until now performed these tasks:

-create q1 (multiconsumer)

-add r1 as subscriber to q1

-enq in q1 with recipient r1

-event based job j1 with queue_spec='j1,r1' (job should execute the dequeue procedure )

problem is that job does not fire (tried also without specifying the agent name... only time that it fires is when the message is enqueued without any recipients, but dequeue fails because there is no consumer specified )

I seacrhed the internet for a concrete example how to create a event based job on enqueueing with recipients, but no luck

Is the flow ok? do I have to perfom something else?

May it be that I hit

Bug 9946875  Scheduler event-based job does not fire when there is a subscriber on AQ queue

Regards Florin

Comments
Post Details
Added on Jul 5 2019
0 comments
146 views