Home » Server Options » Streams & AQ » Sql Statement for to see if the job is in Queue or not? (Oracle 11g)
Sql Statement for to see if the job is in Queue or not? [message #633531] Fri, 20 February 2015 14:38 Go to next message
gentleman777us
Messages: 122
Registered: April 2005
Senior Member
Hi,

Iam new to AQ's. Iam modifying existing queues to single consumer. What is the sql statment to check for the queues to make sure that my modification are working fine.

Thanks
Re: Sql Statement for to see if the job is in Queue or not? [message #633532 is a reply to message #633531] Fri, 20 February 2015 15:24 Go to previous messageGo to next message
Michel Cadot
Messages: 65208
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Maybe checking DBA/ALL/USER_QUEUES% views.

I'm really surprised that someone who has been working with Oracle database for 10 years is not able to query DICT view or read Database Reference book.

[Updated on: Fri, 20 February 2015 15:26]

Report message to a moderator

Re: Sql Statement for to see if the job is in Queue or not? [message #633534 is a reply to message #633532] Fri, 20 February 2015 15:29 Go to previous messageGo to next message
BlackSwan
Messages: 25720
Registered: January 2009
Location: SoCal
Senior Member
> Iam modifying existing queues to single consumer.

using COPY & PASTE show us how you know which to modify & show us how exactly you modified them.
Re: Sql Statement for to see if the job is in Queue or not? [message #633537 is a reply to message #633534] Fri, 20 February 2015 15:53 Go to previous messageGo to next message
gentleman777us
Messages: 122
Registered: April 2005
Senior Member
I know these tables very well, However I could not find some of the jobs in those tables. I was wondering if there are other tables I should be looking.
Re: Sql Statement for to see if the job is in Queue or not? [message #633546 is a reply to message #633537] Sat, 21 February 2015 00:51 Go to previous message
Michel Cadot
Messages: 65208
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

As we don't know which tables you know and which "jobs" you see and which ones you don't see, we can't help.

[Updated on: Sat, 21 February 2015 01:08]

Report message to a moderator

Previous Topic: messages not consuming from MQ to AQ
Next Topic: MGW and MQ Message Duplication
Goto Forum:
  


Current Time: Fri Nov 24 17:49:17 CST 2017

Total time taken to generate the page: 0.02411 seconds