> -----Original Message-----
> From: pgadmin-support-owner@postgresql.org
> [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Andrus
> Sent: 13 April 2006 12:38
> To: pgadmin-support@postgresql.org
> Subject: Re: [pgadmin-support] how to create backup copies
>
> >> pgagent tries to execute 1_1.bat file !
> >
> > That's normal - the script you enter in pgAdmin is written to the
> > temporary batch file at runtime and executed. That's
> required to allow
> > you to target scripts at any agent host.
> >
> > So anyway, does
> C:\DOCUME~1\postgres\LOCAL~1\Temp\pgaD591.tmp\1_1.bat
> > exist, and if so what's in it?
>
> This directory does not exist.
> Only C:\DOCUME~1\postgres\LOCAL~1\Temp directory exists.
>
> I verified, user postgres has Full Control rights to
> C:\DOCUME~1\postgres directory.
I setup your batch files as closely as I could here and with the
exception of the date code it all worked perfectly (the date code
included /'s here - I assume that's not an issue for you).
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?
Thanks, Dave.