Message-ID: <441FF966.2020202@computer.org>
Date: Tue, 21 Mar 2006 14:02:30 +0100
From: Alexis Paul Bertolini <bertolini@computer.org>
User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317)
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: Job queue, how would you implement this?
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Dear all,

I have implemented a job queue table where various apps can add jobs to 
the queue and other daemons then execute them. A basic producer-consumer 
pattern. Each tuple in the queue has the basic info such as job to be 
done, when it should be done, who should do it, a flag marking it completed.

The consumer thus selects from the queue all jobs who scheduled in the 
past (<=CURRENT_TIMESTAMP) and are not flagged. Then flags them upon 
succesfull completion.

I now wish to implement repeating scheduled jobs, like "every 5 
minutes", "every morning at 7.00am" and so on. How could I do this?

Any suggestions are welcome and if necessary I can provide you with more 
info.

Thanks

Alex.