citusdata / citusdata/pg_cron

How can I activate the pg_cron scheduler session?

Open
#302 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
C
Stars
3.9k
Forks
260
Avg merge
5d 5h
Merged PRs (30d)
1

Description

I am using the pg_cron extension for scheduled tasks in PostgreSQL. While monitoring active sessions due to intermittent interruptions in my database, I noticed that the 'postgres' user was running a long-lasting session. This session had an Application Name of: 'pg_cron scheduler' and a command of;
`update cron.job_run_details set status = $1, return_message = $2, end_time = $3 where runid = $4.
`
Since the session duration was excessively long, I terminated this session, and afterward, my jobs stopped running. How can I re-enable the session?

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.