I have also tried that. When i create a new job I think some rows should
be written to the tables in the pgagent schema. But when I am checking
physically the tables there is no data. Is that so due to service of
Thanks & Best Regards
[mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of Dave Page
Sent: Monday, June 25, 2007 1:17 PM
To: Vishal Arora
Subject: Re: [pgadmin-support] PgAgent does not works
Vishal Arora wrote:
>> From: Dave Page <dpage(at)postgresql(dot)org>
>> To: Vishal Arora <aroravishal22(at)hotmail(dot)com>
>> CC: pgadmin-support(at)postgresql(dot)org
>> Subject: Re: [pgadmin-support] PgAgent does not works
>> Date: Sun, 24 Jun 2007 20:46:53 +0100
>> Vishal Arora wrote:
>>> I want to run some jobs in postgresql database using pgAgent. I
>>> installed PGAdmin III on my windows XP machine.
>>> I tried by scheduling small job like inserting data into a table.
>>> 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
Do you have anything listed in the host agent field? If so, please
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
In response to
pgadmin-support by date
|Next:||From: Dave Page||Date: 2007-06-25 09:46:20|
|Subject: Re: PgAgent does not works|
|Previous:||From: Furkan KARAYEL||Date: 2007-06-25 08:52:22|