You realise you just described the very project you saw me write a
presentation on today right?
:-p
On 2/2/09, Gregory Stark <stark@enterprisedb.com> wrote:
> Christopher Browne <cbbrowne@gmail.com> writes:
>
>> - Managing jobs (e.g. - "pgcron")
>
> A number of people have mentioned a job scheduler. I think a job scheduler
> entirely inside Postgres would be a terrible idea.
>
> However a cron daemon which used Postgres as a storage backend would be very
> cool. It could then provide SQL functions to manipulate the schedule and
> allow
> you to set jobs that call database functions using the existing connection
> instead of forcing you to write an external script.
>
> This is something someone could do with no special database background, the
> hard part is finding a cron source base which is flexible enough to extend
> to
> use a database backend. I'm under the impression most cron daemons are based
> on pretty old and ossified source bases and are burdened by a lot of legacy
> compatibility requirements.
>
> --
> Gregory Stark
> EnterpriseDB http://www.enterprisedb.com
> Ask me about EnterpriseDB's 24x7 Postgres support!
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com