Re: PgAgent does not works

Vishal Arora wrote:
>
> Please find the event log and dump of pgAgent schema.

From the dump file, this is the only schedule present:

COPY pga_schedule (jscid, jscjobid, jscname, jscdesc, jscenabled, jscstart,
jscend, jscminutes, jschours, jscweekdays, jscmonthdays, jscmonths) FROM
stdin;
1 1 sch1 t 2007-06-25 14:33:01+05:30 2008-06-25
00:00:00+05:30
{f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f}
{f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f} {f,f,f,f,f,f,f}
{f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f}
{f,f,f,f,f,f,f,f,f,f,f,f}
\.

Those arrays of f's are true or false booleans in arrays of minutes,
hours, weekdays, monthsdays and months, each corresponding to the check
list boxes in the Schedule configuration dialog (see
http://www.pgadmin.org/docs/1.6/pgagent-schedules.html). Because all of
them are false in your case, there is effectively no schedule defined.
you must define at least one time element to trigger the schedule!

As for the eventlog, well, there aren't *any* pgagent entries present.
Are you sure it's installed and running as a service?

Regards, Dave.