Re: Sheduler in Postgres - Mailing list pgsql-general

From Christopher Browne
Subject Re: Sheduler in Postgres
Date
Msg-id m3hdmt8oj6.fsf@knuth.knuth.cbbrowne.com
Whole thread Raw
In response to Sheduler in Postgres  (Együd Csaba <csegyud@vnet.hu>)
Responses Re: Sheduler in Postgres
List pgsql-general
The world rejoiced as csegyud@vnet.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)

pgsql-general by date:

Previous
From: Christopher Browne
Date:
Subject: Re: Postgres 8 and Slony-1
Next
From: Christopher Browne
Date:
Subject: Re: any body able to access news.postgresql.org recently?