Re: PgAgent does not works

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

Vishal Arora wrote:
> Hi
>
> I am sending the event file and dump once again. Sorry for trouble.

OK, that looks a little more like I'd expect.

So, the event log contains a of messages like:

Couldn't create connection: fe_sendauth: no password supplied.

(to get rid of the garbage before that, register pgaevent.dll using 
regsvr32).

So you need to specify the password - see the bottom section of 
http://www.pgadmin.org/docs/1.6/pgagent-install.html which discusses the 
database password.

The database dump does also specify a schedule now - from an eyeball of 
the arrays it looks like it's setup to run at 16:40 every Monday which 
ties up with the job record which has a next runtime value of 2007-06-25 
16:40:00+05:30.

Regards, Dave.