Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Scheduling a script and reporting errors
Message
De
02/02/2012 13:59:26
 
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Scripting
Versions des environnements
SQL Server:
SQL Server 2005
Divers
Thread ID:
01534326
Message ID:
01534330
Vues:
27
>>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform