Skip site navigation (1) Skip section navigation (2)

Re: FW: pgAgent job limit

From: "Dave Page" <dpage(at)pgadmin(dot)org>
To: "Roberts, Jon" <Jon(dot)Roberts(at)asurion(dot)com>
Cc: pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>, "Lucas, Craig" <Craig(dot)Lucas(at)asurion(dot)com>
Subject: Re: FW: pgAgent job limit
Date: 2008-03-20 08:26:58
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgadmin-hackers
On Wed, Mar 19, 2008 at 4:32 PM, Roberts, Jon <Jon(dot)Roberts(at)asurion(dot)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:
PostgreSQL UK 2008 Conference:

In response to

pgadmin-hackers by date

Next:From: svnDate: 2008-03-20 11:31:31
Subject: SVN Commit by dpage: r7178 - branches/REL-1_8_0_EDB/pgadmin3/pgadmin/frm
Previous:From: Guillaume LelargeDate: 2008-03-19 18:55:35
Subject: Re: Romanian Translation

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group