why my postgres job stop running?

3.1k views Asked by At

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?

enter image description here

Windows Server 2008
PostgreSQL 9.3.2, compiled by Visual C++ build 1600, 64-bit

1

There are 1 answers

0
Juan Carlos Oropeza On BEST ANSWER

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. enter image description here