Skip site navigation (1) Skip section navigation (2)

Re: PgAgent does not works

From: "Khan, Mahmood Ahram" <Mahmood(dot)Khan(at)in(dot)unisys(dot)com>
To: "Dave Page" <dpage(at)postgresql(dot)org>,"Vishal Arora" <aroravishal22(at)hotmail(dot)com>
Cc: <pgadmin-support(at)postgresql(dot)org>
Subject: Re: PgAgent does not works
Date: 2007-06-25 08:59:30
Message-ID: D566E8CF3538B54D95B925CB69CB4D2A04B8A03D@inblr-exch1.eu.uis.unisys.com (view raw or flat)
Thread:
Lists: pgadmin-support
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
pgagent.

Thanks & Best Regards
 
M.AHRAM KHAN 
-----Original Message-----
From: pgadmin-support-owner(at)postgresql(dot)org
[mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of Dave Page
Sent: Monday, June 25, 2007 1:17 PM
To: Vishal Arora
Cc: pgadmin-support(at)postgresql(dot)org
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:
>>>
>>> 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.

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

In response to

Responses

pgadmin-support by date

Next:From: Dave PageDate: 2007-06-25 09:46:20
Subject: Re: PgAgent does not works
Previous:From: Furkan KARAYELDate: 2007-06-25 08:52:22
Subject: question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group