Re: Scheduled jobs

From: Olleg Samojlov <olleg(at)telecom(dot)mipt(dot)ru>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Scheduled jobs
Date: 2003-05-22 11:57:12
Message-ID: baidul$2249$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I worked on project at GBorg to implement:

> - a specified moment
> - a time of the day/month/year
> - recurring at a time interval

But now the project is frozen for some time, exist only UML.

Expected features were:

1. All transactions from job spool performed in one connection serially.
So on multy processors servers spooled jobs will eat only one CPU.
And job performed in expected order.
2. Guarantee launch job from spool in none guarantee time, even if
server crashed when job transaction not ended.

Cron can't implement this.

--
Olleg

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruno Wolff III 2003-05-22 12:34:01 Getting schema security in 7.4 with psql?
Previous Message Zeugswetter Andreas SB SD 2003-05-22 11:15:33 Re: Pruning useless tables for queries