Postgres Pro
Downloads
Home   >   mailing lists

Re: pgAgent: How to get run log for specific job - Mailing list pgadmin-hackers

From Muhammad Imtiaz
Subject Re: pgAgent: How to get run log for specific job
Date
Msg-id CANwR1OTNR0nvSGW4Xsp4OR623Y+2y7S7jthJ2nZenPZnMvV0Yg@mail.gmail.com
Whole thread Raw
In response to pgAgent: How to get run log for specific job  (周志勤 <joe.zhou@dualhelios.com>)
List pgadmin-hackers
Tree view
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.zhou@dualhelios.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

pgadmin-hackers by date:

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