From joe.zhou@dualhelios.com Sat May 23 18:09:50 2026 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s79kA-003zoa-GN for pgadmin-hackers@arkaria.postgresql.org; Wed, 15 May 2024 08:12:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1s79kA-00BouX-JA for pgadmin-hackers@arkaria.postgresql.org; Wed, 15 May 2024 08:12:10 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s75pw-008JG0-PJ for pgadmin-hackers@lists.postgresql.org; Wed, 15 May 2024 04:01:52 +0000 Received: from smtpbgeu2.qq.com ([18.194.254.142]) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s75pj-000Ini-22 for pgadmin-hackers@postgresql.org; Wed, 15 May 2024 04:01:51 +0000 X-QQ-mid: bizesmtpsz14t1715745692tdc5ku X-QQ-Originating-IP: DO2XxgV/84eRZuEtJJ7C1HxADiB5Wx/CFbNzjYbD1u4= Received: from JoeDHsemi ( [122.238.81.140]) by bizesmtp.qq.com (ESMTP) with SMTP id 0 for ; Wed, 15 May 2024 12:01:30 +0800 (CST) X-QQ-SSF: 0140000A00000050B000000A0000000 X-QQ-FEAT: uLCNpEXBa0rdtyrIiy/rIM6zQDkIYXm6d5ndJGliO5K++wfhhp/hLb7yvALtF yt8SnEGV59InbbvURA3s0ZHaerf8E4sQUs733ekZo1oEFfuE7IU32nq5V4x8hQB8WckW/0W bvWcUHyWQchRYmaT/1j8IcWYM9E0N912U0mYlXqOXM9plbyOu3Znm1o+CX8xqsJaiZr11Nl dVDC2GVUyDpqLSK6iEoSsez2zg8Ggf5KMAnO4h7n96clJ5f9l5lNTgkdREikZy4pnoX3xjs AiTCdKPR1yAhMLFbxKHOFQ+s3AVWgALMz5Wqgf3Ga6WxRzQyLYVvapWwGfXtIY/z9hyuiQE HQlUhCGl+QUAxdh9t5Th6AmJuOkPfyZARATscqr X-QQ-GoodBg: 2 X-BIZMAIL-ID: 18316965033086824055 Date: Wed, 15 May 2024 12:01:31 +0800 From: =?GB2312?B?1tzWvsfa?= To: pgadmin-hackers Subject: pgAgent: How to get run log for specific job X-Priority: 3 X-GUID: 89AD686C-9813-4340-9519-0C0039E69672 X-Has-Attach: no X-Mailer: Foxmail 7.2.25.245[cn] Mime-Version: 1.0 Message-ID: Content-Type: multipart/alternative; boundary="----=_001_NextPart110232786672_=----" X-QQ-SENDSIZE: 520 Feedback-ID: bizesmtpsz:dualhelios.com:qybglogicsvrsz:qybglogicsvrsz3a-0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. ------=_001_NextPart110232786672_=---- Content-Type: text/plain; charset="GB2312" Content-Transfer-Encoding: base64 SGkgUGdhZG1pbiBIYWNrZXJzDQoNCldvdWxkIHlvdSBwbGVhc2UgYWR2aXNlIHdoZXJlIHRvIGZp bmQgdGhlIHJ1biBsb2cgZm9yIGVhY2ggY29uZmlndXJlZCBqb2I/IERvIHdlIGhhdmUgZG9jdW1l bnRhdGlvbiBmb3IgdGhpcz8NCg0KVGhhbmtzIGFuZCBiZXN0IHJlZ2FyZHMsDQpKb2UNCg0KDQoN CmpvZS56aG91QGR1YWxoZWxpb3MuY29tDQo= ------=_001_NextPart110232786672_=---- Content-Type: text/html; charset="GB2312" Content-Transfer-Encoding: quoted-printable =0A
Thanks= for your information, Muhammad


=0A
=0A
joe.zhou@dualhelios.com
=0A
 
Date: 2024-05-15 16:38
To: =E5=91=A8=E5= =BF=97=E5=8B=A4
Subject: R= e: pgAgent: How to get run log for specific job
Hi , 
You can query the different log table as follow:

=E2=80=A2 pgagent.pga_joblog=0A
= =E2=80=A2 pgagent.pga_jobsteplog
=0A
For example=
SELECT * FROM pgagent.pga_joblog

=
Regards,
Imtiaz 


On Wed, 15 May 2024, 13:08 =E5=91=A8=E5=BF=97=E5=8B= =A4, <joe.zhou@dualhelios.com> wrote:
=
=0A
Hi Pgadmin Hacke= rs

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
=0A
=0A
=0A ------=_001_NextPart355586575810_=------