Re: Scheduled jobs

From: Christopher Browne <cbbrowne(at)cbbrowne(dot)com>
To: Zlatko Michailov <zmichailov(at)yahoo(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Scheduled jobs
Date: 2003-05-12 22:38:14
Message-ID: 20030512223814.5D54286F@cbbrowne.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Zlatko Wrote:
> I didn't find any documentation mentioning scheduled jobs. I assume
> there is no such a feature yet. I would like to implement it if
> someone helps me with the development process (I am brand new to
> OpenSource projects).

> Basically the feature should include scheduling function exeution at:
> - postmaster startup
> - postmaster shutdown
> - a specified moment
> - a time of the day/month/year
> - recurring at a time interval

Have you ever considered using cron?

- It is available on every Unix.
- It may readily be compiled for Cygwin.

It seems preposterous to imagine that reimplementing the functionality
of cron would significantly add to the functionality of PostgreSQL.

If you really want a unified way of accessing crontabs, then feel free
to write some plpgsql functions that are "wrappers" for cron...
--
(concatenate 'string "aa454" "@freenet.carleton.ca")
http://www.ntlug.org/~cbbrowne/unix.html
FLORIDA: Relax, Retire, Re Vote.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Nigel J. Andrews 2003-05-12 22:38:59 Re: Scheduled jobs
Previous Message Tom Lane 2003-05-12 22:27:26 Re: Scheduled jobs