Re: Scheduled jobs - Mailing list pgsql-hackers

From scott.marlowe
Subject Re: Scheduled jobs
Date
Msg-id Pine.LNX.4.33.0305131548130.29172-100000@css120.ihs.com
Whole thread Raw
In response to Re: Scheduled jobs  (Þórhallur Hálfdánarson <tolli@tol.li>)
List pgsql-hackers
OK, here's an idea.  You write a set of stored procs that let you do 
something like:

insert into batch_jobs ('.....  I'm not sure what we'd put here...)

then, postgresql has a crontab entry that uses something like redhats 
runparts script to run the SQL commands it finds in the table.

I.e. the jobs could be scheduled by something as simple as a query, and 
removed as well.  Just need a postgresql cron that runs every 5 minutes or 
whatever resolution you need.



pgsql-hackers by date:

Previous
From: Þórhallur Hálfdánarson
Date:
Subject: Re: Scheduled jobs
Next
From: Tom Lane
Date:
Subject: Re: [INTERFACES] Last round (I think) of FE/BE protocol changes