How to create recurrence schedule event?

From: Quang Thoi <Quang_Thoi(at)symantec(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: How to create recurrence schedule event?
Date: 2013-09-23 18:53:47
Message-ID: 571602E8CBF2CE4B8D025AD126A299632B5A75BA85@TUS1XCHEVSPIN32.SYMC.SYMANTEC.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I am trying to port sybase codes to posgresql. I have looked into the postgresql documentation
but couldn't find good information on how to create an equivalent recurrence event
which similar to the sybase codes below.

Can some one please help?

sybase codes:

create event PURGE_ORDER schedule
start time '00:00:00' every 30 minutes
on ( 'Monday', 'Tuesday', 'Wednesday', 'Thursday', 'Friday','Saturday', 'Sunday' )

handler begin

declare @value varchar(128);
call cleanup_order();
end;

Thanks,
QT

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Raymond O'Donnell 2013-09-23 18:55:59 Re: How to create recurrence schedule event?
Previous Message Ray Stell 2013-09-23 18:00:27 Re: streaming replication not working