Re: where I can find the error message for pgagent jobs

On Mon, Jun 11, 2018 at 9:56 AM, a <372660931(at)qq(dot)com> wrote:

> Hey thanks so much.
>
> I found the error msg as "Couldn't get a connection to the database!"
>
> I've searched internet with the issue, some may say replace pgpass.conf as
> follow:
>
> "*localhost:5432:[dbname]:postgres:[password]*"
>
> but after I changed, the job returns a "i" as last result, which is a
> internal failure if I'm not wrong.
>

> do you have any idea of how to get it work?
>
Please share the content of the table: 'pgagent.pga_jobsteplog'.

-- Thanks, Ashesh

>
> ------------------ Original ------------------
> *From: * "Ashesh Vashi";<ashesh(dot)vashi(at)enterprisedb(dot)com>;
> *Send time:* Monday, Jun 11, 2018 12:39 PM
> *To:* "a"<372660931(at)qq(dot)com>;
> *Cc:* "pgsql-general"<pgsql-general(at)postgresql(dot)org>;
> *Subject: * Re: where I can find the error message for pgagent jobs
>
>
> Please use "pgadmin-support(at)postgresql(dot)org" for any pgAdmin/pgAgent
> related questions, bugs.
>
> On Mon, Jun 11, 2018 at 9:33 AM, a <372660931(at)qq(dot)com> wrote:
>
>> Hi all
>>
>> I set up a pgagent job, but it says the job was failed.
>>
>> But where I can have a look on error report message??
>>
>> I'm using pgadmin 4.3, pgagent 3.4, postgresql 10, the platform is
>> windows server 2008
>>
> You can find them in window's EventViewer.
>
> -- Thanks, Ashesh
>
>>
>> Thank you so much.
>>
>
>