Vishal Arora wrote:
pgAgent -u postgres -p XXXX hostaddr=127.0.0.1 dbname=postgres user=postgres
Hmm, OK - can you please add -l 2 to that to increase the log output, and send me a dump of that from eventviewer once it's run long enough to have missed a job, along with a pg_dump of your pgagent schema from the postgres database.
thanks, Dave ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend