Обсуждение: PG_CRON logging

Поиск
Список
Период
Сортировка

PG_CRON logging

От
Rajin Raj
Дата:
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 

Re: PG_CRON logging

От
"David G. Johnston"
Дата:
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.