Re: pgAgent

do $$

declare

    job_id int;

begin

    /* add a job and get its id: */

    insert into 

        pgagent.pga_job (

        jobjclid

        , jobname

        ) 

    values 

        (

        1 /*1=Routine Maintenance*/

        , 'DELETE_NAMES' /* job name */

        ) 

    returning 

        jobid 

    into 

        job_id;

    /* add a step to the job: */

    insert into 

        pgagent.pga_jobstep (jstjobid, jstname, jstkind, jstcode, jstdbname) 

    values 

        (

            job_id

            , 'DELETE_NAMES' /* step name */

            , 's'                    /* sql step */

            , 'BEGIN DELETE_NAMES; END;'  /* the sql to run */

            , 'somedatabase'                  /* the name of the database to run the step against */

        );

    /* add a schedule to the job. This one runs every day at midnight: */

    insert into pgagent.pga_schedule (

jscjobid

, jscname

, jscdesc

, jscminutes

, jschours

, jscweekdays

, jscmonthdays

, jscmonths

, jscenabled

, jscstart

, jscend)

    values(

job_id

, 'schedule name'

, ''

, '{t,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f}'

, '{t,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f}'

, '{f,f,f,f,f,f,f}'

, '{f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f}'

, '{f,f,f,f,f,f,f,f,f,f,f,f}'

, true

, '2015-04-06 00:00:00'

, NULL

    );

end $$;