From: Dave Page <[EMAIL PROTECTED]>
To: Vishal Arora <[EMAIL PROTECTED]>
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 [EMAIL PROTECTED] 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
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
