MIME-Version: 1.0
References: <B8972392D30C51E5+202405151200281007011@dualhelios.com>
In-Reply-To: <B8972392D30C51E5+202405151200281007011@dualhelios.com>
From: Muhammad Imtiaz <imtiaz.m@bitnine.net>
Date: Wed, 15 May 2024 13:38:51 +0500
Message-ID: 
 <CANwR1OTNR0nvSGW4Xsp4OR623Y+2y7S7jthJ2nZenPZnMvV0Yg@mail.gmail.com>
Subject: Re: pgAgent: How to get run log for specific job
To: =?UTF-8?B?5ZGo5b+X5Yuk?= <joe.zhou@dualhelios.com>
Cc: pgadmin-hackers <pgadmin-hackers@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000fe6acc06187a0c55"
Archived-At: 
 <https://www.postgresql.org/message-id/CANwR1OTNR0nvSGW4Xsp4OR623Y%2B2y7S7jthJ2nZenPZnMvV0Yg%40mail.gmail.com>
Precedence: bulk

--000000000000fe6acc06187a0c55
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hi ,
You can query the different log table as follow:

=E2=80=A2 pgagent.pga_joblog
=E2=80=A2 pgagent.pga_jobsteplog

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@dualhelio=
s.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
>
> ------------------------------
> joe.zhou@dualhelios.com
>

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

<div dir=3D"auto">Hi ,=C2=A0<div dir=3D"auto">You can query the different l=
og table as follow:</div><div dir=3D"auto"><br></div><div dir=3D"auto">=E2=
=80=A2 pgagent.pga_joblog
<br>=E2=80=A2 pgagent.pga_jobsteplog</div><div dir=3D"auto">
<br>For example<br>SELECT * FROM pgagent.pga_joblog<br></div><div dir=3D"au=
to"><br></div><div dir=3D"auto">Regards,</div><div dir=3D"auto">Imtiaz=C2=
=A0</div><div dir=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"n=
oreferrer noreferrer" target=3D"_blank">joe.zhou@dualhelios.com</a>&gt; wro=
te:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;b=
order-left:1px #ccc solid;padding-left:1ex"><div>
<div><span></span>Hi Pgadmin Hackers</div><div><br></div><div>Would you ple=
ase advise where to find the run log for each configured job? Do we have do=
cumentation for this?</div><div><br></div><div>Thanks and best regards,</di=
v><div>Joe</div>
<div><br></div><hr style=3D"width:210px;height:1px" color=3D"#b5c4df" size=
=3D"1" align=3D"left">
<div><span><div style=3D"MARGIN:10px;FONT-FAMILY:verdana;FONT-SIZE:10pt"><d=
iv><a href=3D"mailto:joe.zhou@dualhelios.com" rel=3D"noreferrer noreferrer =
noreferrer" target=3D"_blank">joe.zhou@dualhelios.com</a></div></div></span=
></div>
</div></blockquote></div>

--000000000000fe6acc06187a0c55--