Re: Time triggered events

From: Volkan YAZICI <yazicivo(at)ttnet(dot)net(dot)tr>
To: Elvis Henríquez <henriquez(dot)elvis(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Time triggered events
Date: 2006-09-14 13:16:47
Message-ID: 20060914131646.GB1439@alamut
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Sep 14 09:08, Elvis Henríquez wrote:
> I remember to have read once some time ago something about time
> triggered events in PostgreSQL, like Oracle's and M$ SqlServer. Is it
> already implemented in PostgreSQL ? If so, how could I use it ?

You can use cron or pgAgent xtra comes with pgAdmin [@ pgadmin.org] for
that purpose. From pgAgent documentation:

pgAgent runs 'jobs', each of which consists of steps and schedules. To
configure jobs on your server, browse to the database in which the
pgAgent database objects were created using pgAdmin. A Jobs node will
be displayed, under which individual jobs are shown. New jobs may be
created, and existing jobs modified in the same way as any other
object in pgAdmin.

Regards.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Ellen Cyran 2006-09-14 13:17:30 Re: After how many updates should a vacuum be performed?
Previous Message Mr. Dan 2006-09-14 13:14:29 Re: COPY FROM command v8.1.4