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.