Re: Scheduled jobs

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: Christopher Browne <cbbrowne(at)cbbrowne(dot)com>
Cc: Zlatko Michailov <zmichailov(at)yahoo(dot)com>, <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Scheduled jobs
Date: 2003-05-12 22:56:02
Message-ID: Pine.LNX.4.33.0305121655320.27454-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

For windows, look up wincron, I used it back in the day. don't know if
it's still an up to date package, but it was great back when NT4.0 still
held some small attraction to me.

On Mon, 12 May 2003, Christopher Browne wrote:

> 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.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2003-05-12 23:01:34 Re: PostgreSQL Cookbook Site Down
Previous Message Josh Berkus 2003-05-12 22:46:39 Re: How are null's stored?