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

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

Thanks for your information, Muhammad

joe(dot)zhou(at)dualhelios(dot)com

From: Muhammad Imtiaz
Date: 2024-05-15 16:38
To: 周志勤
CC: pgadmin-hackers
Subject: Re: pgAgent: How to get run log for specific job
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

Browse pgadmin-hackers by date

  From Date Subject
Next Message Akshay Joshi 2024-05-15 09:36:27 [pgadmin-org/pgadmin4] f833ce: Trying to fix the OSX build failure
Previous Message Muhammad Imtiaz 2024-05-15 08:38:51 Re: pgAgent: How to get run log for specific job