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.