Re: How to create recurrence schedule event?

hxreno1 <hxreno1@xxxxxxxxx> · Tue, 24 Sep 2013 09:10:16 +0800



      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