Note, if you have a lot of records in your table a 'retrieve all' might cause problems, and a retrieve/delete in batches is the preferred way to clean up your table
I woke up to the realization that I need to purge this entity when it grew to 6M records. I tried this module (https://marketplace.mendix.com/link/component/117292). It took me 20 mins to simply to extract the latest 10K records, and they never got removed. Mendix grew my database size till it simply hit the limit. Maybe, Mendix was creating some back up data, or it was growth of a roll back segment…
Anyways, how can I start purging System.ScheduledEventInformation entity with 6M records in it and growing at 10K records per day?
Mendix: “We'll be implementing an automatic cleanup mechanism in the coming months” (see idea 1714)