From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Ramesh T <rameshparnanditech(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Pgagent |
Date: | 2015-04-13 15:17:56 |
Message-ID: | 552BDE24.7070408@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Ramesh T | 2015-04-13 15:55:09 | Re: Pgagent |
Previous Message | Jim Nasby | 2015-04-13 14:42:35 | Re: schema or database |