>>Hi,
>>
>>I've been asked to schedule a .cmd file to run under Windows scheduler.
>>
>>this is the contents of the file:
>>
>>
echo on
>>
>>sqlcmd -d cman -i backupHQ.txt
>>
>>copy E:\MyPath\CManHQ.bak \\Myserver\CMan\xchange\
>>
>>pause
>>
>>I know the first thing I need to do is get rid of the pause command.
>>
>>I haven't messed with this kind of thing in years so would appreciate any guidance on how to get the output of the commands to get stored in a text file or if any errors occurred to get them included in the Event Log.
>
>Did you already check sqlcmd parameters and samples in BOL?
No, because this is really a windows command thing rather than a SQL Server thing, I think