Re: pgAdmin - pgAgent problems

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