1 package SL::BackgroundJob::CleanBackgroundJobHistory;
3 use parent qw(SL::BackgroundJob::Base);
5 use SL::DB::BackgroundJobHistory;
8 $_[0]->create_standard_job('0 3 * * *'); # daily at 3:00 am
15 my $options = $db_obj->data_as_hash;
16 $options->{retention_success} ||= 14;
17 $options->{retention_failure} ||= 3 * 30;
19 my $today = DateTime->today_local;
21 for my $status (qw(success failure)) {
22 SL::DB::Manager::BackgroundJobHistory->delete_all(where => [ status => $status,
23 run_at => { lt => $today->clone->subtract(days => $options->{"retention_${status}"}) } ]);