Home » Server Options » Streams & AQ » How AQ is related to dbms_job
icon14.gif  How AQ is related to dbms_job [message #126479] Tue, 05 July 2005 03:33 Go to next message
d.dineshkumar
Messages: 211
Registered: April 2005
Location: Kolkatta
Senior Member
hi gurus,
I am new to Advance Queuing(AQ) .How dbms_job is related with AQ.Is AQ is for messaging purpose only.or it will behave same as dbms_job.If what is the difference.

Please reply,,
Thanks
Dinesh
Re: How AQ is related to dbms_job [message #126501 is a reply to message #126479] Tue, 05 July 2005 04:44 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Hi,

DBMS_JOB is a job scheduler only. It may or may not kickoff jobs that use AQ technology. In Oracle 10g, there is a better scheduler called DBMS_SCHEDULER.

AQ is a queuing technology that is used to asynchronous enque, deque, and propagate messages (the payload).

The “PL/SQL Packages and Types Reference” Manual contains more complete descriptions of both.

Best regards.

Frank
Re: How AQ is related to dbms_job [message #126504 is a reply to message #126501] Tue, 05 July 2005 05:20 Go to previous messageGo to next message
d.dineshkumar
Messages: 211
Registered: April 2005
Location: Kolkatta
Senior Member
hi,
Frank thanks for your reply.Actually one of my procedure is running currently through the dbms_job.But i have been told that the procedure should go with AQ.

So can you please explain,how i will put this oracle stored procedure in a AQ,and how it will behave.

Thanks

With regards
Dinesh
Re: How AQ is related to dbms_job [message #126509 is a reply to message #126504] Tue, 05 July 2005 05:36 Go to previous messageGo to next message
d.dineshkumar
Messages: 211
Registered: April 2005
Location: Kolkatta
Senior Member
Hi frank,
I got a link in asktom,but unable to understand it,can u pls explain it(don't mind).

---Message Strat Here-------------
Tom,

My question is related with the original question. I made a copy of your
"notifyCB" procedure in my 8.17 environment but when I compiled the procedure ,
it gave me "PLS-00201: identifier 'SYS.AQ$_REG_INFO' must be declared" error.
When I asked my DBA to look into, he replied me back that this object does not
exist in 8i but it exist in 10G.

I neeed to call a pl/sql procedure after a message is enqueued in a queue, how
would I do it in 8.1.7 environment?

Thanks for your help.

Suhail


Followup:
this was a new feature in 9i -- plsql based callbacks.



http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96587/qwnew.htm#969817
---------Message End Here------------

My environment is 9i,then how can i substitute my dbms_job for submitting the procedure with AQ for submitting the same procedure.

Thanks
Dinesh
Re: How AQ is related to dbms_job [message #127029 is a reply to message #126509] Fri, 08 July 2005 00:46 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Chapter 2 of the same manual explains the callback mechanism:

"CALLBACK - Specifies the action to be performed on message notification.

For e-mail notifications, the form is mailto://xyz@company.com

For AQ PL/SQL Callback, use plsql://<schema>.<procedure>?PR=0 for raw message payload or plsql://<schema>.<procedure>?PR=1 for ADT message payload converted to XML"

Best regards.

Frank
Re: How AQ is related to dbms_job [message #127154 is a reply to message #127029] Sat, 09 July 2005 05:18 Go to previous message
d.dineshkumar
Messages: 211
Registered: April 2005
Location: Kolkatta
Senior Member
Thanks A Lot Frank
For ur answer.
Regards
Dinesh
Previous Topic: Streams on 30 Instances
Next Topic: Dequeueing messages from exception queues.
Goto Forum:
  


Current Time: Fri Mar 29 01:44:41 CDT 2024