cron RLS
Is it not possible to update the cron via SQL? I tried a simple
update cron.job SET active = is_active WHERE jobid = 13; but the RLS on cron blocks me (even when running as the postgres role from the dashboard). And that RLS is locked so I cannot make changes. Is the best way forward for me to delete/recreate the job every time? How are others handling this?