Thread: Scheduled Tasks
View Single Post
Old 01-14-2009, 10:07 AM   #5 (permalink)
dvendt
Registered User
 
Join Date: Jan 2009
Posts: 3
OS: w2k server


Re: Scheduled Tasks

For some reason, this does not work in Scheduled tasks, it runs fine manually when I run it from command prompt. Here is the bat file contents, very simple, but does not work. Now, the xcopy process takes over 2 hours on this. I noticed the scheduled tasks result is 0x0, which is ok and the log shows that it ran, but it did not. Any ideas?

net use f: \\192.168.1.101\f$ /user:server1\administrator password
start "SQL COPY" /min xcopy "c:\program files\microsoft sql server\mssql\backup\*.*" f:\backups\backup09\*.*
dvendt is offline   Reply With Quote