© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabase•6mo ago•
16 replies
Pondia

Cron do schedule but never execute

Hello,

The job are well scheduled but never executed.

I have followed this guide https://supabase.com/docs/guides/troubleshooting/pgcron-debugging-guide-n1KTaz but everything is fine regarding the cron scheduler.

job_run_details table remain empty.


CREATE EXTENSION IF NOT EXISTS pg_cron;

GRANT usage ON SCHEMA cron TO postgres;
GRANT all privileges ON ALL TABLES IN SCHEMA cron TO postgres;
CREATE EXTENSION IF NOT EXISTS pg_cron;

GRANT usage ON SCHEMA cron TO postgres;
GRANT all privileges ON ALL TABLES IN SCHEMA cron TO postgres;


On the SQL editor

SELECT cron.schedule(
    'job_in_1_minutes',
    TO_CHAR(NOW() + interval '1 minutes', 'MI HH24 DD MM') || ' *',
    $$SELECT now()$$ 
);


SELECT cron.schedule(
    'job_in_2_minutes',
    TO_CHAR(NOW() + interval '2 minutes', 'MI HH24 DD MM') || ' *',
    $$SELECT now()$$ 
);


SELECT cron.schedule(
    'job_in_5_minutes',
    TO_CHAR(NOW() + interval '5 minutes', 'MI HH24 DD MM') || ' *',
    $$SELECT now()$$  
);
SELECT cron.schedule(
    'job_in_1_minutes',
    TO_CHAR(NOW() + interval '1 minutes', 'MI HH24 DD MM') || ' *',
    $$SELECT now()$$ 
);


SELECT cron.schedule(
    'job_in_2_minutes',
    TO_CHAR(NOW() + interval '2 minutes', 'MI HH24 DD MM') || ' *',
    $$SELECT now()$$ 
);


SELECT cron.schedule(
    'job_in_5_minutes',
    TO_CHAR(NOW() + interval '5 minutes', 'MI HH24 DD MM') || ' *',
    $$SELECT now()$$  
);
Supabase banner
SupabaseJoin
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.
45,816Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

Broken CRON Schedule?
SupabaseSSupabase / help-and-questions
2mo ago
Is it possible to execute Functions on a schedule?
SupabaseSSupabase / help-and-questions
4y ago
How do I add for a cron?
SupabaseSSupabase / help-and-questions
4mo ago
Cron job in job table but not executing
SupabaseSSupabase / help-and-questions
14mo ago