Re: Schedule Jobs in Postgres

> My company ZONIAC INDIA PVT LTD is extensively using Pstgres as the
> database for their product. And right now I'm in need to schedule a job that
> inserts a record into a table based on the value of a field in another
> table. How can I do this? Please let me know as soon as possible. It is
> URGENT!!!.

> I'm not talking about triggers because no other event is triggering this
> particular job. This job must be scheduled so that as soon as the difference
> between the value in a field and a particular date is reduced to 1 day, a
> record is inserted in another table.

I guess I don't understand the above.

It seems to me you have several possibilities here.

1. If what you are looking for is to do something when the column
value is updated to be within one day of the date in question, then
you have something which could be done with a trigger funcion.

2. If what you're looking for is something that happens in relation to
a change between the external date and an [unchanged] column
value, you may be able to accomplish this with a cron job that
does the time comparison. Would a daily or hourly or once-per-minute
cron job satisfy your stated requirement that this job be scheduled
'as soon as ....'

3. If neither of the above meets your conditions, you probably have a
task that is beyond pgsql's current state of development, as it is
a real-time task. As I recall, Oracle has the ability to schedule
jobs, but I don't recall the time granularity it uses.
--
Mike Nolan

3.