sql/Pg-upgrade2/background_job_change_create_periodic_invoices_to_daily.sql

   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
   4 UPDATE background_jobs
   5 SET cron_spec   = '0 3 * * *',
   6     next_run_at = CAST(current_date AS timestamp) + CAST(
   7                     (CASE
   8                      WHEN extract('hour' FROM current_timestamp) < 3 THEN '3 hours'
   9                      ELSE                                                 '1 day 3 hours'
  10                      END) AS interval
  11                   )
  12 WHERE package_name = 'CreatePeriodicInvoices';