Re: PgAgent does not works

Vishal Arora wrote:
> 
> 
> 
>> From: Dave Page <dpage@postgresql.org>
>> To: Vishal Arora <aroravishal22@hotmail.com>
>> CC: pgadmin-support@postgresql.org
>> Subject: Re: [pgadmin-support] PgAgent does not works
>> Date: Sun, 24 Jun 2007 20:46:53 +0100
>>
>> Vishal Arora wrote:
>>>
>>> Hi,
>>>
>>> I want to run some jobs in postgresql  database using pgAgent. I have 
>>> installed PGAdmin III on my windows XP machine.
>>>
>>> I tried by scheduling small job like inserting data into a table. The 
>>> job is created, I ahve scheduled to run every minute but it is not  
>>> running at all. I can not see it in the statistics tab in pgAdmin as 
>>> well. The job is shown in the pga_jobs table in pgagent schema. I 
>>> have installed it as service and its running perfectly fine.
>>>
>>> Kindly let me know whats going wrong.
>>>
>>
>> Are the pgAdmin maintenance DB, the DB containing the pgagent schema, 
>> and the DB that pgagent connects to all the same one?
> 
> Yes it is the postgres database as mentioned in the installation guide.

Do you have anything listed in the host agent field? If so, please 
remove it.

Regards, Dave.