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?
------------------ Original ------------------
From: "Ashesh Vashi";<ashesh.vashi@xxxxxxxxxxxxxxxx>;
Send time: Monday, Jun 11, 2018 12:39 PM
To: "a"<372660931@xxxxxx>;
Cc: "pgsql-general"<pgsql-general@xxxxxxxxxxxxxx>;
Subject: Re: where I can find the error message for pgagent jobs
On Mon, Jun 11, 2018 at 9:33 AM, a <372660931@xxxxxx> wrote:
Hi allI 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.