postgresqlpgadminpgadmin-4pgagent

postgres pgagent job status

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?

Solution

  • 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.