> Can you reinstall the agent service with the '-l 2' option (no quotes)
> and see if anything useful gets logged in the event log please?
Here is application log:
13.04.2006 17:46:25 pgAgent Information None 0 N/A STAR Clearing inactive
connections
13.04.2006 17:46:15 pgAgent Information None 0 N/A STAR Sleeping...
13.04.2006 17:46:15 pgAgent Information None 0 N/A STAR Checking for jobs to
run
13.04.2006 17:46:06 pgAgent Information None 0 N/A STAR Destroying job
thread for job 1
13.04.2006 17:46:06 pgAgent Information None 0 N/A STAR Completed job: 1
13.04.2006 17:46:06 pgAgent Information None 0 N/A STAR Returning connection
to database postgres
13.04.2006 17:46:05 pgAgent Warning None 0 N/A STAR Couldn't execute script:
C:\DOCUME~1\postgres\LOCALS~1\Temp\pgaD7AC.tmp\1_1.bat
13.04.2006 17:46:05 pgAgent Information None 0 N/A STAR Executing script
file: C:\DOCUME~1\postgres\LOCALS~1\Temp\pgaD7AC.tmp\1_1.bat
13.04.2006 17:46:05 pgAgent Information None 0 N/A STAR Executing batch step
1 (part of job 1)
13.04.2006 17:46:05 pgAgent Information None 0 N/A STAR Sleeping...
13.04.2006 17:46:05 pgAgent Information None 0 N/A STAR Starting job: 1
13.04.2006 17:46:05 pgAgent Information None 0 N/A STAR Allocating new
connection to database postgres
13.04.2006 17:46:03 pgAgent Information None 0 N/A STAR Creating DB
connection: hostaddr=127.0.0.1 user=postgres password=secret
dbname=postgres
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
