batch file - Automate backup command not working in job scheduling -
i using postgresql 8.4 on windows server 2012 box. have made configuration pgagent job scheduling. need schedule auto backup on daily basis on system using job scheduling. searched net , created batch file , located file path in job scheduling.
if run batch file on server works fine, when call using scheduling in postgresql goes in running stage, not give kind of result.
below command used taking backup:
"c:\program files (86)\path\to\bin" pg_dump.exe -i -h hostname -u username -f c -b -v -f "backup\file\path\filename.backup" databasename this command working fine on command prompt , when calling batch file, not give output postgresql job scheduling.
does have idea kind of issue?
Comments
Post a Comment