Thanks Colby
Yes even in my tests FactoryQL was chaching the Stored Procedure Groups, but I wanted an official comment on that. I do hope that Ignition does it by the time, I need to move to it.
I will create scheduled SP groups along with the Trigger Based to verify that the trigger ones have been executed and werent lost for any reason including disconnection to DB.
I would hope that someone will realize the need for Store and Forward for SP groups also in ignition and implement that in a near future release.