Re: Pgagent

On 04/13/2015 07:22 AM, Ramesh T wrote:
> Hi,
> in steps>definition->
> do
> $body$
> begin
> perform delete_empty_parts();
> end;
> $body$
>
> delete_empty_parts is the function
>
> i do selected SQL option in step process.Right clicked on job chosen run
> now it getting failed(On error i selected failed,if select success it
> getting success)

Is there an error message in the Postgres logs?

>
> I'm running function on particular database and selected today dates..
>
> but function wasn't executed.

How do you know?

>
> let me know how to set it function in pgagent..
>
> On Mon, Apr 13, 2015 at 7:26 PM, Adrian Klaver
> <adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>> wrote:
>
>     On 04/13/2015 06:53 AM, Ramesh T wrote:
>
>         Hi all,
>                    i have a function to delete data from table.Where i
>         need to
>         place function in pgagent.in <http://pgagent.in>
>         <http://pgagent.in> definition section can
>         i select SQL or BATCH ..?
>
>         or else any other method.?
>
>
>     See here:
>
>     http://www.pgadmin.org/docs/__dev/pgagent.html
>     <http://www.pgadmin.org/docs/dev/pgagent.html>
>
>         Any Help..
>
>
>
>     --
>     Adrian Klaver
>     adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
>
>


--
Adrian Klaver
adrian.klaver@aklaver.com