Triggering of mail whenever there is a change in decision table rule which is delegated to Business people
We have a client requirement that whenever there is a change in Decision table rules( which are delegated to business people, they can change and test the flow accordingly.)
We have implemented in such a manner that, we have created a DB trigger at PR4_Rule(internal Pega database table) so whenever the pxUpdateDatetime is getting updated, trigger is getting executed which in turn writing a entry into another database table(which we have created). On that table we configured an agent to process the entries and send the mail.
My question : 1. Is somebody already worked on this kind of requirement? Any alternative suggestion
2. Is there any kind of unforeseen issue can happen if we go with this approach.
***Updated by moderator: Lochan to add Categories***
I have tried the approach you specified but challenge what I faced is, in Declare Class you can not create Declarative rules.
There is no specific condition to configure a agent but with the approach we implemented through DB trigger we can not directly trigger a activity to send mail so, on trigger of DB trigger we write a record in another database table and on that table we configured a agent to process the records and send.