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.kla...@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.kla...@aklaver.com <mailto:adrian.kla...@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.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com> >> >> >> > > -- > Adrian Klaver > adrian.kla...@aklaver.com >