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

[Ashesh Vashi <ashesh.vashi@xxxxxxxxxxxxxxxx>]

On Mon, Jun 11, 2018 at 9:56 AM, a <372660931@xxxxxx> 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.vashi@enterprisedb.com>;

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

Please use "pgadmin-support@postgresql.org" for any pgAdmin/pgAgent related questions, bugs.

On Mon, Jun 11, 2018 at 9:33 AM, a <372660931@xxxxxx> 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.