Schedule Jobs in Postgres

From: "Madhavi Daroor" <madhavi(at)zoniac(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Schedule Jobs in Postgres
Date: 2003-05-14 11:17:03
Message-ID: NHBBKMLNGKEMDMCGAMFNKEGNCAAA.madhavi@zoniac.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,
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.

Eagerly awaiting your reply,
Thanx
Madhavi Daroor

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tzvetan Tzankov 2003-05-14 12:02:09 disk space usage enlarging despite vacuuming
Previous Message Rob Larter 2003-05-14 10:55:47 query help