Re: How to create recurrence schedule event?

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
>