April 28, 2005 at 9:48 am
I am trying to create a SQL Server job that zips my backup files using InfoZip. I have created a one line command that works fine when typed from the command line, however it will not work within the SQL Server job. This is the command I'm using which states the destination and source. These files are also located on a different server compared to the SQL Server application. I have defined a environmental variable for the path which is okay and filled out each job category correctly (to include picking OS not TSQL), but I still get these error messages within SQL Server. Can any one help please?
Command is:
zip \\epen?\bac\user\bkups.zip \\epen?\bac\user\*.bak
Error:
zip warning: name not matched: \\epen?\bac\user\*.bak
(zip error: Nothing to do! \\epen?\bac\user\bkups.zip). Process Exit Code 12. The step failed.
April 28, 2005 at 9:56 am
make sure the account that starts the SQLSERVERAGENT service has access to \\epen?\bac\user
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply