Обсуждение: Re: Pgagent

Поиск
Список
Период
Сортировка

Re: Pgagent

От
Adrian Klaver
Дата:
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

Re: Pgagent

От
Adrian Klaver
Дата:
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

Re: Pgagent

От
Ramesh T
Дата:
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

Re: Pgagent

От
Ramesh T
Дата:
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.klaver@aklaver.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.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