PG_CRON - Mailing list pgsql-admin

From Geri Wright
Subject PG_CRON
Date
Msg-id CAKSgRY7WH35tmhbyo33M3ahY2jyjzViM+v0LoX5mZpF0aPK1Dg@mail.gmail.com
Whole thread Raw
Responses Re: PG_CRON
List 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

pgsql-admin by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Ora2pg migration
Next
From: Erik Wienhold
Date:
Subject: Re: PG_CRON