Question
![](/profiles/pega_profile/modules/pega_user_image/assets/user-icon.png)
![](/profiles/pega_profile/modules/pega_user_image/assets/user-icon.png)
Tata Consultancy Services
US
Last activity: 17 Feb 2021 10:12 EST
Stored Procedure
What rules in Pega if any other than Connect-SQL use the stored procedures?
-
Like (0)
-
Share this page Facebook Twitter LinkedIn Email Copying... Copied!
Accepted Solution
![](https://accounts.pega.com/sites/default/files/pega-user-image/280/REG-280155.png?source=PUMINIT)
![](https://accounts.pega.com/sites/default/files/pega-user-image/280/REG-280155.png?source=PUMINIT)
Pegasystems Inc.
IN
Hi,
There are few store procedure, for example SP sppr_sys_reservequeueitem_b is used purely for agent processing.
There are different SP which are called by different rules based on their design
Not sure how much I have answered your query, but if I have got it wrong then please provide exact details that you looking for. I might be able to check for that
Thanks
![](https://accounts.pega.com/sites/default/files/pega-user-image/280/REG-280155.png?source=PUMINIT)
![](https://accounts.pega.com/sites/default/files/pega-user-image/280/REG-280155.png?source=PUMINIT)
Pegasystems Inc.
IN
Hi,
Little confused about you query
But if you asking how to call store procedure in pega then answer is through connect-sql rule only
https://pdn.pega.com/node/8755/book_pdf
But if you looking for which all rules refer store procedure then there might be a lot of places
Thank You
![](/profiles/pega_profile/modules/pega_user_image/assets/user-icon.png)
![](/profiles/pega_profile/modules/pega_user_image/assets/user-icon.png)
Tata Consultancy Services
US
which other rules can directly use store procedure ?
-
Andrzej Radosh
![](/profiles/pega_profile/modules/pega_user_image/assets/user-icon.png)
![](/profiles/pega_profile/modules/pega_user_image/assets/user-icon.png)
Tata Consultancy Services
US
Please let me know if anyone has any other suggestions
Accepted Solution
![](https://accounts.pega.com/sites/default/files/pega-user-image/280/REG-280155.png?source=PUMINIT)
![](https://accounts.pega.com/sites/default/files/pega-user-image/280/REG-280155.png?source=PUMINIT)
Pegasystems Inc.
IN
Hi,
There are few store procedure, for example SP sppr_sys_reservequeueitem_b is used purely for agent processing.
There are different SP which are called by different rules based on their design
Not sure how much I have answered your query, but if I have got it wrong then please provide exact details that you looking for. I might be able to check for that
Thanks
![](/profiles/pega_profile/modules/pega_user_image/assets/user-icon.png)
![](/profiles/pega_profile/modules/pega_user_image/assets/user-icon.png)
CapGemini
IN
Hi Shekhar,
How to optimize "sppr_sys_reservequeueitem" stored procedure ??
![](https://accounts.pega.com/sites/default/files/styles/user_image/public/1689967000/33d14adb-5b1a-4774-86a8-1c1709752301.jpg?itok=8pZjQZre)
![](https://accounts.pega.com/sites/default/files/styles/user_image/public/1689967000/33d14adb-5b1a-4774-86a8-1c1709752301.jpg?itok=8pZjQZre)
Pegasystems Inc.
IN
Hi Rajesh,
Which version of prpc are you using?I guess we can do some modification in stored procedure query for 7.1.8 to optimize it.
Thanks,
Abhinav