7
enable scheduling extension (beyond pg_cron)
Source: supabase/supabase#16250 · opened by @jonathanstanley
I know Supabase has [pg_cron]( which can be used to create recurring schedules.
But is there an option for scheduling a function to occur ONCE (at a specific future time)? For example
• [pgagent]( )
• [pg_timetable](
I haven't used either of these, however pg_timetable looks very nice. For example ["self-destructive" jobs]( can be set to run once (such as to terminate a free trial at a given date).
I realize technically this could be done with pg_cron by having the cron removal as part of the action. however, it would be nice to use regular dates (eg ISO) for one-off date scheduling. schedule("2022-09-27 18:00:00.000",()=>{//do stuff}) and not have to convert a date to a cron format.
But is there an option for scheduling a function to occur ONCE (at a specific future time)? For example
• [pgagent]( )
• [pg_timetable](
I haven't used either of these, however pg_timetable looks very nice. For example ["self-destructive" jobs]( can be set to run once (such as to terminate a free trial at a given date).
I realize technically this could be done with pg_cron by having the cron removal as part of the action. however, it would be nice to use regular dates (eg ISO) for one-off date scheduling. schedule("2022-09-27 18:00:00.000",()=>{//do stuff}) and not have to convert a date to a cron format.
No pledges yet. Be the first to back this.
No comments yet.