Re: Job scheduling in Postgre

On Thu, Dec 4, 2008 at 3:50 PM, Robert Treat
<xzilla(at)users(dot)sourceforge(dot)net> wrote:
> On Tuesday 02 December 2008 07:11:02 A. Kretschmer wrote:
>> am Tue, dem 02.12.2008, um 16:45:16 +0500 mailte IPS folgendes:
>> > I have certain jobs to be executed automatically at a given interval of
>> > time in the postgre SQL database. Is their any utility/feature available
>> > in Postgre to do so.
>>
>> No, use the scheduler from the OS, CRON for example (UNIX).
>>
>
> There is a database level schedular called (iirc) pgAgent, which comes bundled
> with pgAdmin. I think it's so well hidden because it comes as a part of a
> tool which is only used by a small subset of the community. I had hopes that
> it might follow autovacuums path and get moved into a contrib module and
> possibly integrated into the backend some day, but I haven't seen much push
> in that direction.

It would need to be ported to C first (it's currently wxWidgets/C++).
We are packaging it separately now though.

http://www.pgadmin.org/docs/1.8/pgagent.html
http://www.pgadmin.org/download/pgagent.php

--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com