Kyuda
  • OVERVIEW
  • Platform
    • Introduction
  • Builder
    • Introduction
    • Setup
  • Flow
    • Introduction
    • Nodes
      • Camunda
      • Salesforce
        • PushTopic Events
      • RabbitMQ
      • Sentry
      • Minio
      • Google
      • Papertrail
  • Extensions
    • Introduction
  • Organisation
    • Introduction
    • Members
    • Billing
    • Subscriptions
      • Developer
      • Professional
      • Team
      • Enterprise
    • Single Sign On (SSO)
    • Environment
    • Limits
  • PRIVACY AND SECURITY
    • Introduction
    • Security Best Practices
    • Subprocessors
    • PGP Key
  • ARTICLES
    • Productivity 101
    • Automation 101
  • ABOUT
  • STATUS
  • Alpine Code
Powered by GitBook
On this page

Was this helpful?

  1. Builder

Setup

CREATE EXTENSION pg_cron;
SELECT cron.schedule_in_database('remove-completed-process-instances', '0 4 * * 0', $$DELETE FROM "public"."process_instance" WHERE ("state" = 'COMPLETED')$$, 'postgres');
DELETE FROM "public"."process_instance" WHERE ("state" = 'COMPLETED')
PreviousIntroductionNextIntroduction

Last updated 1 year ago

Was this helpful?