Re: FW: pgAgent job limit

On Wed, Mar 19, 2008 at 4:32 PM, Roberts, Jon <Jon.Roberts@asurion.com> wrote:
> I was thinking about this part of the pgagent.sql script the other day:
>
>  INSERT INTO pgagent.pga_jobclass (jclname) VALUES ('Routine
>  Maintenance');
>  INSERT INTO pgagent.pga_jobclass (jclname) VALUES ('Data Import');
>  INSERT INTO pgagent.pga_jobclass (jclname) VALUES ('Data Export');
>  INSERT INTO pgagent.pga_jobclass (jclname) VALUES ('Data
>  Summarisation');
>  INSERT INTO pgagent.pga_jobclass (jclname) VALUES ('Miscellaneous');
>
>  You don't have a UI for these job classes but they are used to populate
>  the drop down list when creating a new job.  If someone wants to
>  insert/update/delete any of these job classes, they have to do this
>  manually without a UI.  Based on this, I would think we could add this
>  feature without a UI change.

2 wrongs don't make a right.

>  I also thought about putting the job throttling into the job class by
>  throttling jobs based on the job class they are in.  It would take more
>  changes to the SQL code but I think it would be doable and add more
>  flexibility.

I would be less averse to letting that slide in.

--
Dave Page
EnterpriseDB UK Ltd: http://www.enterprisedb.com
PostgreSQL UK 2008 Conference: http://www.postgresql.org.uk