Question
Optum
IN
Last activity: 19 Mar 2022 10:09 EDT
Commit - Job Schedulers
If the requirement is to update data instances in a job scheduler activity, without using commit method how can we persist the data?
We need to connect to external service and based on the response received, we need to update data instances.
This has to be done daily once, so we configured job scheduler. In activity, without using commit is there any way to update the data instances. As using commit method adds guardrail warning.
IKOR Polska
PL
@Karthik KummeraPega should perform commit automatically using deferred save mechanism. When the job scheduler operation is done it closes the session, which should result in commiting all transaction items. How do you perform save operation on the records?
ai4process
PL
@Karthik Kummera @Arkadiusz Job Scheduler run does not commit changes automatically, therefore Commit at the end of Job activity is required.
You could queue the update for each entry to Queue Processor (Pega handles transaction the transaction there) with page snapshot and Queue Immidiately option, but I would consider this as an overkill compared to the requirement and simply add Commit step and justify the warning.
Optum
IN
@DamianM5 @Arkadiusz Thanks for the response.
@Arkadiusz As Damian said, job scheduler does not commit changes automatically. so for now, we will go with the commit method and justify the warning.
Mindtree Ltd
US
@Karthik Kummera You can try with pxCreateRecord/pxUpdateRecord activity which takes care of saving and committing optionally. But this performs the commit for each save of the record. If your intention is to commit once for the entire batch, then explicit commit has to be issued at the end.
Optum
IN
@SanthoshB6893 Thanks Santhosh and will definitely try this.
Updated: 19 Mar 2022 10:09 EDT
Areteans
GB
use savable data page to defer save records, do not use write now at this moment. afterward, when all records are saved, possibly outside of a loop, create a temporary work page of Work- class and call the ootb commitherrorhandling activity using the temppage as primary page, this will commit all the deferred saves. post that clean up and exit the activity.