Question
7
Replies
3715
Views
DXC Technology
Posted: April 5, 2018
Last activity: April 17, 2018
Closed
Solved
System Queue management in SMA and pr_sys_queues table
Dears,
I noticed that the amount of Item Count with Status Scheduled in SMA is very high like and not equal to the count of records in the table pr_sys_queues with column pyitemstatus as Scheduled.
Means my understanding that the table from where this is fetched in SMA is pr_sys_queues is wrong. Could you let me know from which table does SMA populate the details in the section called System Queue Management under Agent Management.
regards,
Jagan
There are multiple queue tables. For example, the SLA queue items would be stored in pr_sys_queues_sla and not pr_sys_queues.
Here is the list of queue tables I see in my 7.3.1 system.
PR_SYS_QUEUE_AUTOTEST
PR_SYS_QUEUE_COL_POP
PR_SYS_QUEUE_COUNT
PR_SYS_QUEUE_EXECREQ_CONN
PR_SYS_QUEUE_EXECREQ_SVC
PR_SYS_QUEUE_FTSINDEXER
PR_SYS_QUEUE_SLA
PR_SYS_QUEUE_STARTFLOWS
PR_SYS_QUEUES