From: | Ramesh T <rameshparnanditech(at)gmail(dot)com> |
---|---|
To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Pgagent |
Date: | 2015-04-13 15:55:09 |
Message-ID: | CAK8Zd=vTS=NL3a-1RgmD-H8jWDeQDW1TwEbnAS_mL8ELrH-U0g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
no error messages.. i checked at PostgreSQL\9.4\data\pg_log
Didn't deleted data from table.after schedule time..
one thing i don't understand ,after set timings and in definition section
also the function works fine individually.
any help..
On Mon, Apr 13, 2015 at 8:47 PM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:
> 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 | Day, David | 2015-04-13 15:57:57 | unexpected error " tables can have at most 1600 columns" |
Previous Message | Adrian Klaver | 2015-04-13 15:17:56 | Re: Pgagent |