1 -- @tag: self_test_background_job
2 -- @description: Hintergrundjob für tägliche Selbsttests
3 -- @depends: release_2_7_0
4 INSERT INTO background_jobs (type, package_name, active, cron_spec, next_run_at)
5 VALUES ('interval', 'SelfTest', true, '20 2 * * *',
6 CAST(current_date AS timestamp) + CAST(
8 WHEN extract('hour' FROM current_timestamp) < 2 THEN '2 hours 20 minutes'
9 ELSE '1 day 2 hours 20 minutes'