Re: [GENERAL] How to create recurrence schedule event?

[hxreno1]

pgAgent is a job scheduler for PostgreSQL which may be managed using 
pgAdmin. Prior to pgAdmin v1.9, pgAgent shipped as part of pgAdmin. From 
pgAdmin v1.9 onwards, pgAgent is shipped as a separate application.

On 09/24/2013 02:53 AM, Quang Thoi wrote:

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