How can I activate the pg_cron scheduler session?
Open
- 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.