PG_CRON logging

Started by Rajin Rajover 5 years ago2 messages
#1Rajin Raj
rajin.raj@opsveda.com

Hi,

Is there way to insert the cron job execution status to a table?
Or any other method to identify the job status without checking the log
file?

*Regards,*
*Rajin *

#2David G. Johnston
david.g.johnston@gmail.com
In reply to: Rajin Raj (#1)
Re: PG_CRON logging

On Tuesday, May 26, 2020, Rajin Raj <rajin.raj@opsveda.com> wrote:

Hi,

Is there way to insert the cron job execution status to a table?
Or any other method to identify the job status without checking the log
file?

Please just pick one list to send emails to. And this isn’t a topic
relevant to -hackers

Simplest solution is to call out to psql in whatever process is being run.
I don’t how, if at all, to get the cron daemon to send output to a custom
target that could do the psql work more generically. Though i do not think
doing So would be a good idea even if it can be done.

David J.