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@xxxxxxxxxxxxxxxx> wrote: > Christopher Browne <cbbrowne@xxxxxxxxx> 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@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
