>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?
If it's not broken, fix it until it is.
My Blog