Re: Scheduled jobs - Mailing list pgsql-hackers

From Olleg Samojlov
Subject Re: Scheduled jobs
Date
Msg-id baidul$2249$1@news.hub.org
Whole thread Raw
In response to Scheduled jobs  (Zlatko Michailov <zmichailov@yahoo.com>)
List 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
willeat 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



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [COMMITTERS] pgsql-server/src backend/commands/variable.c b ...
Next
From: Greg Stark
Date:
Subject: Re: Text format protocol representation