1 -- @tag: background_job_change_create_periodic_invoices_to_daily
2 -- @description: Hintergrundjob zum Erzeugen periodischer Rechnungen täglich ausführen
3 -- @depends: release_3_0_0
5 SET cron_spec = '0 3 * * *',
6 next_run_at = CAST(current_date AS timestamp) + CAST(
8 WHEN extract('hour' FROM current_timestamp) < 3 THEN '3 hours'
12 WHERE package_name = 'CreatePeriodicInvoices';