Re: PgAgent does not works

["Vishal Arora" <aroravishal22(at)hotmail(dot)com>]

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


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

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