Re: Sheduler in Postgres

From: Christopher Browne <cbbrowne(at)acm(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Sheduler in Postgres
Date: 2004-12-11 04:08:45
Message-ID: m3hdmt8oj6.fsf@knuth.knuth.cbbrowne.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

The world rejoiced as csegyud(at)vnet(dot)hu (Együd Csaba) wrote:
> Hi, I should schedule the execution of several stored
> procedures. Now I use an NT service for this, but as far as I know
> e.g. the Oracle has such a thing. It would be great if I could fire
> procedures on a timer basis.
>
> Is there a better solution for this than mine?

Traditionally, PostgreSQL has consciously omitted such things where
they would merely be replicating existing operating system
functionality.

On Unix, "cron" is the traditional service that provides this
functionality.

I think there's a port to Windows NT, so you could presumably use that
if you haven't got any more "native" job scheduler.
--
output = reverse("moc.liamg" "@" "enworbbc")
http://www.ntlug.org/~cbbrowne/lsf.html
"How should I know if it works? That's what beta testers are for. I
only coded it." (Attributed to Linus Torvalds, somewhere in a
posting)

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron Peterson 2004-12-11 04:16:07 Re: information schema extra fields
Previous Message Michael Fuhr 2004-12-11 04:01:39 Re: How to get rid of notices for create table?