why my postgres job stop running?
I create a job to clean the database every day at 01:00.
According to statistic run OK from 3 months. But today i realize the database size was very big so i check the jobs and hasn't run for one month.
Properties say last run was '10/27/2014' and statistics confirm run successful.
Also say next run will be '10/28/2014' but looks like never run and stay frozen since then.
(I'm using dd/mm/yyyy format)
So why stop running?
There is a way to restart the job or should i go and delete and recreate the job?
How can i know a job didn't run?
I guess i can write a code if job isn't successful but what about if never execute?
Windows Server 2008
PostgreSQL 9.3.2, compiled by Visual C++ build 1600, 64-bit
The problem was the pgAgent service wasn't running.
When I Restart the Postgres service:
Postgres service stop
pgAgent stop because is a dependent service
Postgres service start
but pgAgent didn't
Here you can see pgAgent didn't start.
- 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?