Hello Kevin, >>>>Exactly what are you doing to try to schedule it? I am trying to schedule a database back up...using batch File....but it is not happening then i tried to schedule a SQL Script for creating a table on the Database. this is also not functioning....
>>>>How do you determine that it hasn't been scheduled? When i tried to back up the back up file is not created and in the case of Create table there is not any table in the database.
Please respond to the list as well as any individuals. This helps make the archive message thread useful for others who may have a similar problem, and it may draw advice from others who can help.
>>> On Thu, Sep 20, 2007 at 11:01 PM, in message < 116685ec0709202101o7142adabrc5fe851e54f6bca3@mail.gmail.com>, "Yogesh Arora" <yogesh.arora.daffodil@gmail.com> wrote: > Hello Kevin, > First of all, Thanks for your response. > The answer to your Questions > >>>>>What operating system? > I am using the Windows 2003 operating System. >>>>>What did you do to try to schedule these things? > I have created a Batch File of a Command to take the Back of the Database > specified. When i run this file through command Prompt, its run > successfully. But when i try to schedule it., It's not get scheduled and > does not show any errors.
Exactly what are you doing to try to schedule it? How do you determine that it hasn't been scheduled?
> Then i tried to schedule the direct SQL command , but the same result, not > being scheduled. >>>>What were you expecting to see as a result? > Expecting the results of the above. >>>>>>>What did you see, including exact error text, if any? > There are not any Error to show...................................... > > The Query in Batch File is :- > > @echo off > "C:\Program FIles\PostgreSQL\8.2\bin\pg_dump" -U username -f > D:\test\test.sql -F p -C -d -D postgres > > The Password related info is being stored in the PgPass.conf file.......