postgres pgagent job status

postgresql pgadmin pgadmin-4 pgagent
user619 picture user619 · Mar 28, 2018 · Viewed 7.5k times · Source

I have installed PostgreSQL 9.6 in win 10.

Also installed pgAgent for job scheduling.

I have create one job for batch file execute but it showing status 'r','i'. What is the meaning of status field.

I have attached screenshot. image link1 image link2

How can manage log in pgaAgent?

Answer

Jim Jones picture Jim Jones · Mar 28, 2018

These are the statuses of pgAgent:

r running s success f failed i internal failure d aborted

Using pgAdmin you can check the logs by clicking on the step, then on the statistics panel, then you will see what the job "wrote" in the output column.

Related questions

PGAdmin: Not connected to the server or the connection to the server has been closed

i got this problem with postgreSQL, when i do a simple query of anything (CRUD), sometimes it works and almost always shows this message: Not connected to the server or the connection to the server has been closed. I don't …

Read More
PgAdmin fatal error. The appllication server could not be contacted

A couple of days before I have installed on my PC with Windows 7 Professional new version of PgAdmin (version 4). It worked fine, but today it loads slowly and then information window appears with text: "PgAdmin fatal error. The appllication server …

Read More
PgAdmin 4: Cannot edit rows from one table

Something strange is happening with my new created tables in Postgres, I can add data to them, but I cannot use PgAdmin to edit the any row. This is my table columns description: After executing the query to view all …

Read More