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.

How can I select rows from a table where the sum of rows in a joined table is greater than a number?
Generating time series between two dates in PostgreSQL
How to ignore errors with psql \copy meta-command
PostgreSQL 17: pg_upgrade on Windows Server 2019: could not load library "$libdir/adminpack": No such file or directory
How to restore postgres database into another database name
Are PostgreSQL column names case-sensitive?
PHP: exec() returns status '0' (successful) when executing failing PostgreSQL scripts
Is TRUNCATE a DML statement?
Initialize PostgreSQL Container with docker-entrypoint-initdb.d script
pgadmin4 : postgresql application server could not be contacted
Adding a raw select statement to the Knex query builder
Gaps between primary key id in sql table
MSB4057: The target "GetEFProjectMetadata" does not exist in the project. .NET Core 8, Entity Framework Core 8
Prevent DateRangeField overlap in Django model?
Ruby on Rails hashed password using BCrypt not saving to postgres users table
Is it safe to set the statistics target to zero for numeric columns?
Use multiple conflict_target in ON CONFLICT clause
Retrieve similarity score in Python for HNSW vector indexing in PostgreSQL
Sequelize is chopping of nested key length
How to allow mixed integer and numeric parameters in icase
PostgreSQL copy command using STDIN
Error when Loading data into postgresql db
pg_upgrade on Windows cannot write to log file pg_upgrade_internal.log
Pivoting a table using crosstab() in PostgreSQL
Getting error recursive reference to query must not appear within its non-recursive term in postgres
dspace import metadata acknowledges changes doesn't apply them
Running the Postgres CLI client from a Kubernetes jumpbox
Problem Restoring PostgreSQL Database in Docker Container with Symfony
Postgres split time ranges into 1 minute slots, without rounding boundaries
how to store PostgreSQL jsonb using SpringBoot + JPA?