Stored Procedure
What rules in Pega if any other than Connect-SQL use the stored procedures?
which other rules can directly use store procedure ?
Please let me know if anyone has any other suggestions
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
Hi Shekhar,
How to optimize "sppr_sys_reservequeueitem" stored procedure ??
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
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