Re: pgAgent: How to get run log for specific job

From: Muhammad Imtiaz <imtiaz(dot)m(at)bitnine(dot)net>
To: 周志勤 <joe(dot)zhou(at)dualhelios(dot)com>
Cc: pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>
Subject: Re: pgAgent: How to get run log for specific job
Date: 2024-05-15 08:38:51
Message-ID: CANwR1OTNR0nvSGW4Xsp4OR623Y+2y7S7jthJ2nZenPZnMvV0Yg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

Hi ,
You can query the different log table as follow:

• pgagent.pga_joblog
• pgagent.pga_jobsteplog

For example
SELECT * FROM pgagent.pga_joblog

Regards,
Imtiaz

On Wed, 15 May 2024, 13:08 周志勤, <joe(dot)zhou(at)dualhelios(dot)com> wrote:

> Hi Pgadmin Hackers
>
> Would you please advise where to find the run log for each configured job?
> Do we have documentation for this?
>
> Thanks and best regards,
> Joe
>
> ------------------------------
> joe(dot)zhou(at)dualhelios(dot)com
>

In response to

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message 周志勤 2024-05-15 08:44:12 Re: Re: pgAgent: How to get run log for specific job
Previous Message 周志勤 2024-05-15 05:56:12 pgAgent Job issue: Couldn't get a connection to the database when local SQL mode specified in another database other than postgres