Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Scheduling a script and reporting errors
Message
From
02/02/2012 13:59:26
 
General information
Forum:
Microsoft SQL Server
Category:
Scripting
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01534326
Message ID:
01534330
Views:
30
>>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
Frank.

Frank Cazabon
Samaan Systems Ltd.
www.samaansystems.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform