Re: elegant and effective way for running jobs inside a database

2012/3/5 Artur Litwinowicz <admin(at)ybka(dot)com>

> Dear Developers,
> I am looking for elegant and effective way for running jobs inside a
> database or cluster - for now I can not find that solution.
> OK if You say "use cron" or "pgAgent" I say I know that solutions, but
> the are not effective and elegant. Compilation of "pgAgent" is a pain
> (especially wxWidgets usage on system with no X) - it can run jobs with
> minimal 60s periods but what when someone needs run it faster for eg.
> with 5s period ? Of course using cron I can do that but it is not
> effective and elegant solution. Why PostgreSQL can not have so elegant
> solution like Oracle database ? I am working with Oracle databases for
> many years, but I like much more PostgreSQL project but this one
> thing... I can not understand - the lack of jobs inside the database...
>
>
IMHO it is not necessary add this feature to the PostgreSQL core, because
the OS already has the capability to schedule and maintain the tasks.

Best regards,

--
Fabrízio de Royes Mello
Consultoria/Coaching PostgreSQL
>> Blog sobre TI: http://fabriziomello.blogspot.com
>> Perfil Linkedin: http://br.linkedin.com/in/fabriziomello
>> Twitter: http://twitter.com/fabriziomello