Menu
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?
845
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.
To add a new job, right click on the pgAgent Jobs node, and select Create pgAgent Job… from the context menu. When the pgAgent dialog opens, use the tabs on the pgAgent Job dialog to define the steps and schedule that make up a pgAgent job.
pgAgent is a job scheduling agent for Postgres databases, capable of running multi-step batch or shell scripts and SQL tasks on complex schedules. pgAgent is distributed independently. You can download pgAgent from the download area of the pgAdmin website.
Starting with PostgreSQL version 12.5 and higher, Amazon RDS for PostgreSQL now supports the extension pg_cron, a simple cron-based job scheduler for PostgreSQL that runs inside the database.
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.
143
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
