Re: Job queue, how would you implement this?

O Alexis Paul Bertolini έγραψε στις Mar 21, 2006 :

> 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.

The consumer runs from the command line? (i.e. user-action driven?)

> 
> 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?

I think the traditional UNIX "at" framework could be a good
model (or replacement) of the simpler case,
whereas the traditional UNIX "cron" framework could be a good
model (or replacement) of the latter case.
Your requirements photographically point to the above systems.
Are you running on a UNIX machine?

> 
> Any suggestions are welcome and if necessary I can provide you with more 
> info.
> 
> Thanks
> 
> Alex.
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
> 
>                http://www.postgresql.org/docs/faq
> 

-- 
-Achilleus