Schedule Jobs

Crunchy Bridge has a job scheduler to automatically run tasks inside your database. The Scheduler screen is available inside your cluster menu on the left side. You can create jobs with SQL input and schedule your job to run at the increment of your choice.

Creating scheduled jobs

Input your SQL and select the run times.

Information about your scheduled jobs

Crunchy Bridge uses pg_cron extension to run scheduled jobs. Information about your jobs can be found at

select * from cron.job;
Copy

Errors and run history can be found at:

select * from cron.job_run_details;
Copy