multica/server/migrations/076_task_usage_pgcron_exten...

11 lines
290 B
SQL

DROP FUNCTION IF EXISTS task_usage_rollup_lag_seconds();
DO $$
BEGIN
IF EXISTS (SELECT 1 FROM pg_extension WHERE extname = 'pg_cron') THEN
PERFORM cron.unschedule('rollup_task_usage_daily')
FROM cron.job WHERE jobname = 'rollup_task_usage_daily';
END IF;
END
$$;