Re: PgAgent does not works

[Dave Page <dpage(at)postgresql(dot)org>]

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.