Re: PgAgent does not works

-----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(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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)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-----