testing cron jobs with pg_cron

trying to figure out how to get cron jobs working. I've added the extension and enabled it following this
https://supabase.com/blog/postgres-as-a-cron-server
When I create a job to run using the following query

select
  cron.schedule(
    'cron-test-2', -- name of the cron job
    '* * * * *', -- every minute
    $$
     UPDATE notifications
     SET updated_at = now()
     WHERE uuid="674b2fb9-fb77-4d7e-879f-273453a88f01"
    $$
  );

select
  cron.schedule(
    'cron-test-2', -- name of the cron job
    '* * * * *', -- every minute
    $$
     UPDATE notifications
     SET updated_at = now()
     WHERE uuid="674b2fb9-fb77-4d7e-879f-273453a88f01"
    $$
  );

it successfully returns a schedule with an id. But it doesn't seem to work.
I've got no way of debugging this or even listing cron jobs.
Can anyone help?

Supabase

Postgres as a CRON Server

Running repetitive tasks with your Postgres database.

Supabase•4y ago•

5 replies

stukennedy

testing cron jobs with pg_cron

select
  cron.schedule(
    'cron-test-2', -- name of the cron job
    '* * * * *', -- every minute
    $$
     UPDATE notifications
     SET updated_at = now()
     WHERE uuid="674b2fb9-fb77-4d7e-879f-273453a88f01"
    $$
  );

select
  cron.schedule(
    'cron-test-2', -- name of the cron job
    '* * * * *', -- every minute
    $$
     UPDATE notifications
     SET updated_at = now()
     WHERE uuid="674b2fb9-fb77-4d7e-879f-273453a88f01"
    $$
  );

it successfully returns a schedule with an id. But it doesn't seem to work.
I've got no way of debugging this or even listing cron jobs.
Can anyone help?

Supabase

Postgres as a CRON Server

Running repetitive tasks with your Postgres database.

testing cron jobs with pg_cron

Similar Threads

testing cron jobs with pg_cron

Similar Threads

Similar Threads

Similar Threads