Re: Pgagent

Поиск
Список
Период
Сортировка
От Ramesh T
Тема Re: Pgagent
Дата
Msg-id CAK8Zd=sMU-cZc_Jb_G9EfStm=dEF5WU7U8L30rfx2Yo3TLZRUw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Pgagent  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
Дерево обсуждения
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)

I'm running function on particular database and selected today dates..

but function wasn't executed.

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> 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> definition section can
i select SQL or BATCH ..?

or else any other method.?

See here:

http://www.pgadmin.org/docs/dev/pgagent.html

Any Help..


--
Adrian Klaver
adrian.klaver@aklaver.com

В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Re: Hot standby problems: consistent state not reached, no connection to master server.
Следующее
От: Ramesh T
Дата:
Сообщение: Pgagent