Date: Wed, 15 May 2024 16:44:12 +0800
From: =?UTF-8?B?5ZGo5b+X5Yuk?= <joe.zhou@dualhelios.com>
To: "Muhammad Imtiaz" <imtiaz.m@bitnine.net>
Cc: pgadmin-hackers <pgadmin-hackers@postgresql.org>
Subject: Re: Re: pgAgent: How to get run log for specific job
References: <B8972392D30C51E5+202405151200281007011@dualhelios.com>,
	<CANwR1OTNR0nvSGW4Xsp4OR623Y+2y7S7jthJ2nZenPZnMvV0Yg@mail.gmail.com>
Mime-Version: 1.0
Message-ID: <CB74EC11224ACD0B+2024051516423623834813@dualhelios.com>
Content-Type: multipart/alternative;
	boundary="----=_001_NextPart355586575810_=----"
Feedback-ID: bizesmtpsz:dualhelios.com:qybglogicsvrsz:qybglogicsvrsz3a-0
Archived-At: 
 <https://www.postgresql.org/message-id/CB74EC11224ACD0B%2B2024051516423623834813%40dualhelios.com>
Precedence: bulk

This is a multi-part message in MIME format.

------=_001_NextPart355586575810_=----
Content-Type: text/plain;
	charset="UTF-8"
Content-Transfer-Encoding: base64

VGhhbmtzIGZvciB5b3VyIGluZm9ybWF0aW9uLCBNdWhhbW1hZA0KDQoNCg0KDQoNCmpvZS56aG91
QGR1YWxoZWxpb3MuY29tDQogDQpGcm9tOiBNdWhhbW1hZCBJbXRpYXoNCkRhdGU6IDIwMjQtMDUt
MTUgMTY6MzgNClRvOiDlkajlv5fli6QNCkNDOiBwZ2FkbWluLWhhY2tlcnMNClN1YmplY3Q6IFJl
OiBwZ0FnZW50OiBIb3cgdG8gZ2V0IHJ1biBsb2cgZm9yIHNwZWNpZmljIGpvYg0KSGkgLCANCllv
dSBjYW4gcXVlcnkgdGhlIGRpZmZlcmVudCBsb2cgdGFibGUgYXMgZm9sbG93Og0KDQrigKIgcGdh
Z2VudC5wZ2Ffam9ibG9nIA0K4oCiIHBnYWdlbnQucGdhX2pvYnN0ZXBsb2cNCg0KRm9yIGV4YW1w
bGUNClNFTEVDVCAqIEZST00gcGdhZ2VudC5wZ2Ffam9ibG9nDQoNClJlZ2FyZHMsDQpJbXRpYXog
DQoNCg0KT24gV2VkLCAxNSBNYXkgMjAyNCwgMTM6MDgg5ZGo5b+X5YukLCA8am9lLnpob3VAZHVh
bGhlbGlvcy5jb20+IHdyb3RlOg0KSGkgUGdhZG1pbiBIYWNrZXJzDQoNCldvdWxkIHlvdSBwbGVh
c2UgYWR2aXNlIHdoZXJlIHRvIGZpbmQgdGhlIHJ1biBsb2cgZm9yIGVhY2ggY29uZmlndXJlZCBq
b2I/IERvIHdlIGhhdmUgZG9jdW1lbnRhdGlvbiBmb3IgdGhpcz8NCg0KVGhhbmtzIGFuZCBiZXN0
IHJlZ2FyZHMsDQpKb2UNCg0KDQoNCmpvZS56aG91QGR1YWxoZWxpb3MuY29tDQo=

------=_001_NextPart355586575810_=----
Content-Type: text/html;
	charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<html><head><meta http-equiv=3D"content-type" content=3D"text/html; charse=
t=3DUTF-8"><style>body { line-height: 1.5; }blockquote { margin-top: 0px; =
margin-bottom: 0px; margin-left: 0.5em; }div.FoxDiv20240515164157177358 { =
}body { font-size: 14px; font-family: "Microsoft YaHei UI"; color: rgb(0, =
0, 0); line-height: 1.5; }</style></head><body>=0A<div><span></span>Thanks=
 for your information, Muhammad</div><div><br></div><div><br></div>=0A<div=
><br></div><hr style=3D"width: 210px; height: 1px;" color=3D"#b5c4df" size=
=3D"1" align=3D"left">=0A<div><span><div style=3D"MARGIN: 10px; FONT-FAMIL=
Y: verdana; FONT-SIZE: 10pt"><div>joe.zhou@dualhelios.com</div></div></spa=
n></div>=0A<blockquote style=3D"margin-Top: 0px; margin-Bottom: 0px; margi=
n-Left: 0.5em; margin-Right: inherit"><div>&nbsp;</div><div style=3D"borde=
r:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm"><div styl=
e=3D"PADDING-RIGHT: 8px; PADDING-LEFT: 8px; FONT-SIZE: 12px;FONT-FAMILY:ta=
homa;COLOR:#000000; BACKGROUND: #efefef; PADDING-BOTTOM: 8px; PADDING-TOP:=
 8px"><div><b>From:</b>&nbsp;<a href=3D"mailto:imtiaz.m@bitnine.net">Muham=
mad Imtiaz</a></div><div><b>Date:</b>&nbsp;2024-05-15&nbsp;16:38</div><div=
><b>To:</b>&nbsp;<a href=3D"mailto:joe.zhou@dualhelios.com">=E5=91=A8=E5=
=BF=97=E5=8B=A4</a></div><div><b>CC:</b>&nbsp;<a href=3D"mailto:pgadmin-ha=
ckers@postgresql.org">pgadmin-hackers</a></div><div><b>Subject:</b>&nbsp;R=
e: pgAgent: How to get run log for specific job</div></div></div><div><div=
 class=3D"FoxDiv20240515164157177358"><div dir=3D"auto">Hi ,&nbsp;<div dir=
=3D"auto">You can query the different log table as follow:</div><div dir=
=3D"auto"><br></div><div dir=3D"auto">=E2=80=A2 pgagent.pga_joblog=0A<br>=
=E2=80=A2 pgagent.pga_jobsteplog</div><div dir=3D"auto">=0A<br>For example=
<br>SELECT * FROM pgagent.pga_joblog<br></div><div dir=3D"auto"><br></div>=
<div dir=3D"auto">Regards,</div><div dir=3D"auto">Imtiaz&nbsp;</div><div d=
ir=3D"auto"><br></div></div><br><div class=3D"gmail_quote"><div dir=3D"ltr=
" class=3D"gmail_attr">On Wed, 15 May 2024, 13:08 =E5=91=A8=E5=BF=97=E5=8B=
=A4, &lt;<a href=3D"mailto:joe.zhou@dualhelios.com" rel=3D"noreferrer nore=
ferrer" target=3D"_blank">joe.zhou@dualhelios.com</a>&gt; wrote:<br></div>=
<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1=
px #ccc solid;padding-left:1ex"><div>=0A<div><span></span>Hi Pgadmin Hacke=
rs</div><div><br></div><div>Would you please advise where to find the run =
log for each configured job? Do we have documentation for this?</div><div>=
<br></div><div>Thanks and best regards,</div><div>Joe</div>=0A<div><br></d=
iv><hr style=3D"width:210px;height:1px" color=3D"#b5c4df" size=3D"1" align=
=3D"left">=0A<div><span><div style=3D"MARGIN:10px;FONT-FAMILY:verdana;FONT=
-SIZE:10pt"><div><a href=3D"mailto:joe.zhou@dualhelios.com" rel=3D"norefer=
rer noreferrer noreferrer" target=3D"_blank">joe.zhou@dualhelios.com</a></=
div></div></span></div>=0A</div></blockquote></div>=0A</div></div></blockq=
uote>=0A</body></html>
------=_001_NextPart355586575810_=------