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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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 <[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. 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 [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
