Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Scheduling a script and reporting errors
Message
 
 
To
02/02/2012 13:43:49
General information
Forum:
Microsoft SQL Server
Category:
Scripting
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01534326
Message ID:
01534328
Views:
43
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform