public inbox for [email protected]  
help / color / mirror / Atom feed
pgAgent: How to get  run log for specific job
3+ messages / 3 participants
[nested] [flat]

* pgAgent: How to get  run log for specific job
@ 2024-05-15 04:01  =?GB2312?B?1tzWvsfa?= <[email protected]>
  0 siblings, 1 reply; 3+ messages in thread

From: =?GB2312?B?1tzWvsfa?= @ 2024-05-15 04:01 UTC (permalink / raw)
  To: pgadmin-hackers

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



[email protected]


^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: pgAgent: How to get run log for specific job
@ 2024-05-15 08:38  Muhammad Imtiaz <[email protected]>
  parent: =?GB2312?B?1tzWvsfa?= <[email protected]>
  0 siblings, 1 reply; 3+ messages in thread

From: Muhammad Imtiaz @ 2024-05-15 08:38 UTC (permalink / raw)
  To: 周志勤 <[email protected]>; +Cc: 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 周志勤, <[email protected]> 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
>
> ------------------------------
> [email protected]
>


^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Re: pgAgent: How to get run log for specific job
@ 2024-05-15 08:44  周志勤 <[email protected]>
  parent: Muhammad Imtiaz <[email protected]>
  0 siblings, 0 replies; 3+ messages in thread

From: 周志勤 @ 2024-05-15 08:44 UTC (permalink / raw)
  To: Muhammad Imtiaz <[email protected]>; +Cc: pgadmin-hackers

Thanks for your information, Muhammad





[email protected]
 
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 周志勤, <[email protected]> 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



[email protected]


^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2024-05-15 08:44 UTC | newest]

Thread overview: 3+ messages (download: mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-05-15 04:01 pgAgent: How to get  run log for specific job =?GB2312?B?1tzWvsfa?= <[email protected]>
2024-05-15 08:38 ` Re: pgAgent: How to get run log for specific job Muhammad Imtiaz <[email protected]>
2024-05-15 08:44   ` Re: Re: pgAgent: How to get run log for specific job 周志勤 <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox