1 -- @tag: emmvee_background_jobs_2
2 -- @description: Hintergrundjobs einrichten
3 -- @depends: emmvee_background_jobs
4 INSERT INTO background_jobs (type, package_name, active, cron_spec, next_run_at)
5 VALUES ('interval', 'CleanBackgroundJobHistory', true, '0 3 * * *',
6 CAST(current_date AS timestamp) + CAST(
8 WHEN extract('hour' FROM current_timestamp) < 3 THEN '3 hours'