PG_CRON

From: Geri Wright <geri(dot)w123(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: PG_CRON
Date: 2024-03-25 15:48:27
Message-ID: CAKSgRY7WH35tmhbyo33M3ahY2jyjzViM+v0LoX5mZpF0aPK1Dg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,
I have pg_cron installed. It's working fine for simple schedules but having
difficulty scheduling a job to run only on the 4th Sunday of the month at 3
am. It seams to ignore the combination of "day of month" and "day of week".
It runs everyday from the 22nd through the 28th. I have tried with the
following schedules.

0 3 22-28 * 0
0 3 22-28 * 7
0 3 22,23,24,25,26,27,28 * 0
0 3 22,23,24,25,26,27,28 * 7

Responses

  • Re: PG_CRON at 2024-03-25 19:04:34 from Erik Wienhold

Browse pgsql-admin by date

  From Date Subject
Next Message Erik Wienhold 2024-03-25 19:04:34 Re: PG_CRON
Previous Message Laurenz Albe 2024-03-25 15:30:12 Re: Ora2pg migration