Thread: Question to pgAgent

Question to pgAgent

From
"Knoch, Sandra"
Date:
<div class="Section1"><p class="MsoNormal">Hi there<p class="MsoNormal"> <p class="MsoNormal"><span lang="EN-US">I try
touse pgAgent as a scheduling service on a Windows machine. I could install everything right and also implemented my
schedulewith a batch script in pgAgent. My problem is that I also installed pgAgent as a service on the windows server
2003but I am not able to start the service. Every time I start the service I get the message: the service started and
thenstopped … because it has nothing to do…. Something like that. So the service is not running which means I do not
getthe automatical backup of my database I would like to have. Does anybody know why the service is always stopping
automaticallyor how I can prevent the service from being stopped? Thank you very much for your help!</span><p
class="MsoNormal"><spanlang="EN-US"> </span><p class="MsoNormal"><span lang="EN-US">Regards</span><p
class="MsoNormal"><spanlang="EN-US">Sandra Knoch</span><p class="MsoNormal"><span lang="EN-US"> </span><p
class="MsoNormal"><spanlang="EN-US"> </span></div> 

Re: Question to pgAgent

From
Ashesh Vashi
Date:
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
EnterpriseDB INDIA: Enterprise Postgres Company

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