Re: pgAdmin - pgAgent problems

["Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>]

Thanks Paolo, I've fixed this in SVN for the next release. Toggle the setting yourself in the meantime, you can just do:

 

UPDATE pgagent.pga_schedule SET jscenabled = TRUE WHERE jscid = 1234

 

In your maintenance DB. Just set to TRUE or FALSE as required, and specify the correct schedule ID instead of 1234 of course!

 

Regards, Dave.

---

From: pgadmin-support-owner(at)postgresql(dot)org [mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of Paolo Saudin
Sent: 16 October 2005 09:08
To: pgadmin-support(at)postgresql(dot)org
Subject: [pgadmin-support] pgAdmin - pgAgent problems

Hi,

    I am using postgresql-8.1-beta3 on WinXP SP2 I installed it with default settings, then I loaded the "pgAgent.sql" script against the postgres database. pgAdmin can now manage jobs. I created a simple job that should insert a row in a test table. All ok. The problem is that I am not able to enable the schedule. When I enter the schedule properties form the "Enable" check box is always grayed out. I check it, clik Ok and exit, but the schedule is still set to not enabled. The ID is one, the start date is set to yesterday and the end one to the future. All the other time properties are set to Every.

At this point I have install the pgAgent service yet, but i think Jobs should be managed even without the service running isn't it?

 

Thanks,

Paolo Saudin