Can't delete or disable cron job
This is the message: Failed to toggle database cron job: Job 5 does not exist or you don't own it
But I still can see it and list it through queries
7 Replies
What are you calling when you get the error?
If you look in the table UI at cron.jobs what is the user that owns the id job?
Deactivate the job or delete it.
Can't see who owns it, I'm the only one in the project
Go to table UI, cron schema, jobs
It is more about what Postgres role created it.
And do you intend to have crons with same function call?
You are using the Cron UI for this?
"supabase_read_only_user"
Mostly the AI Assistant
And the cron ui too
For deletion
But for creation it's the AI
Is the AI signing in as that user?
If so then you need to use it to make the cron.unschedule would be my guess.
I've run that query too