Re: PgAgent does not works

>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.


>Regards, Dave
>
>---------------------------(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

_________________________________________________________________
Picture this � share your photos and you could win big!  
http://www.GETREALPhotoContest.com?ocid=TXT_TAGHM&loc=us