2

PgAdmin shows statistics of each run of a step of pg_agent (job). The list details the run ID, status, result, start & end & duration. The following is how it looks:

enter image description here

How to get it by query command ?

Rino
  • 219
  • 1
  • 6
  • 13

1 Answers1

2

pg_agent create a catalog (like a schema) 'pgagent' for each database, you can query the different log table as follow:

  • pgagent.pga_joblog
  • pgagent.pga_jobsteplog

To get log of all step runs :

SELECT * FROM pgagent.pga_jobsteplog

Best regards, Tim

Timuran Bicer
  • 31
  • 3