Please try to run the pgagent in debug mode and see what is going wrong.
Please refer this link for the details:
Read "pgagent DEBUG <connection-sting>" in the section "Service installation on Windows".
Hope that will help you.
--
Thanks & Regards,
Ashesh Vashi
On Wed, Sep 15, 2010 at 3:16 PM, Knoch, Sandra
<Sandra.Knoch@ipa.fraunhofer.de> wrote:
Hi there
I try to use pgAgent as a scheduling service on a Windows machine. I could install everything right and also implemented my schedule with a batch script in pgAgent. My problem is that I also installed pgAgent as a service on the windows server 2003 but I am not able to start the service. Every time I start the service I get the message: the service started and then stopped … because it has nothing to do…. Something like that. So the service is not running which means I do not get the automatical backup of my database I would like to have. Does anybody know why the service is always stopping automatically or how I can prevent the service from being stopped? Thank you very much for your help!
Regards
Sandra Knoch