> Von: "Francesco Chicchiriccò" <[email protected]> > An: [email protected] > Betreff: Re: cleaning up notification tasks > > On 29/03/2014 10:00, Guido Wimmel wrote: > > Hi, > > > > ok, this makes sense. > > > > I can't see a way to search notification tasks by date, but I assume you > > could build something based on the ids as well (as Syncope uses sequences). > > Generally speaking, tasks don't have timing information: such data is > found in task executions. > > > Scheduled tasks for cleanup might be a nice addition to Syncope core > > (depending on how project specific they usually are). > > > An idea could be to add > > 1. a method to TaskExecDAO for searching task executions (for any > kind of tasks) completed before a certain date/time > 2. a scheduled task for removing tasks that only have executions > completed before a certain date/time > > WDYT?
Yes, this should work, but requires extending a Syncope core class. So, when you said > >> The best way to accomplish this is via a scheduled task [3] (we do this > >> in almost all IAM projects we're involved in): [...] you didn't refer to scheduled tasks in the projects you're involved in that clean up tasks / task executions based on their age, but to scheduled tasks that clean up tasks / task executions based on some other conditions, or even to any scheduled tasks in your projects? Anyway, we don't have an immediate requirement for such clean up tasks, as it will take some time until database size will become a concern. If it becomes important, we could probably provide a contribution again (if no one else has done it already then). There might be some caveats, as normal delete operations are very slow e.g. in Oracle. Regards, Guido
