Re: PgAgent does not works - Mailing list pgadmin-support

From Christophe Chauvet
Subject Re: PgAgent does not works
Date
Msg-id 467F910F.6010309@aznetwork.fr
Whole thread Raw
In response to Re: PgAgent does not works  ("Khan, Mahmood Ahram" <Mahmood.Khan@in.unisys.com>)
List pgadmin-support
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi

Can you reinstall your services with logging enable (option -l)?

C:\Program Files\pgAdmin III\pgAgent INSTALL pgAgent -l 1 -u postgres -p secret hostaddr=127.0.0.1
dbname=postgres user=postgres

And check your Event Viewer.

Regards,

Christophe Chauvet.

Khan, Mahmood Ahram a écrit :
> 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@postgresql.org
> [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Dave Page
> Sent: Monday, June 25, 2007 1:17 PM
> To: Vishal Arora
> Cc: pgadmin-support@postgresql.org
> Subject: Re: [pgadmin-support] 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.
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>        subscribe-nomail command to majordomo@postgresql.org so that your
>        message can get through to the mailing list cleanly
> 
> 
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (MingW32)

iD8DBQFGf5EOMl/S4ZhUIzERAh1BAJ44s/MwmWgE2RryzPQf/lKYopxxEwCfWdf1
R7QbXRICBYaG4DsDPGu/Vjs=
=Jp3Q
-----END PGP SIGNATURE-----


pgadmin-support by date:

Previous
From: Dave Page
Date:
Subject: Re: PgAgent does not works
Next
From: Dave Page
Date:
Subject: Re: Feature requests: QueryTool; key shortcut, output pane unhiding, macros