Run Multiple Stored Procedures in order with a script??
From: Tom (none_at_none.com)
Date: 11/21/04
- Next message: Andrew J. Kelly: "Re: Run Multiple Stored Procedures in order with a script??"
- Previous message: Fany Vargas [MSFT]: "RE: Invalid authorization specification"
- Next in thread: Andrew J. Kelly: "Re: Run Multiple Stored Procedures in order with a script??"
- Reply: Andrew J. Kelly: "Re: Run Multiple Stored Procedures in order with a script??"
- Reply: Nigel Rivett: "RE: Run Multiple Stored Procedures in order with a script??"
- Reply: Larry: "Re: Run Multiple Stored Procedures in order with a script??"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 21 Nov 2004 15:32:16 -0500
Hello. I have to run many sql scripts each day. Sometimes I'll have 100+
scripts to run. The scripts always come in a folder numbered in the order
they need to be run (001 - ScriptA, 002 - ScriptB, etc.).
I've been running them all manaully one by one so that I can look for errors
in the results. I'd love to be able to point a batch file to the folder
with all the scripts, have them run one by one, and have the results output
in one file with:
Results.txt:
001 - ScriptA.sql
Command Completed Successfully
---- 002 - ScriptB.sql Command Completed Successfully --- 003 - ScriptC.sql Error in line 1...etc --- 004 - ScriptD.sql Command Completed Successfully --- etc. I have tried piping them using c:\Scipts\*.sql > c:\AllScripts.sql However, this is often causes problems as sometimes the end of one script will join directly to the start of the first script making statements that don't exist (EndscriptGo).. two statements joint into one. Or other times scripts will be left out for some reason. Piping has caused many problems and isn't trusted anymore. I tried using osql OSQL -Usa -Ppass -Sdb123 -iC:\scripts\001scriptA.sql -oC:\logs\001scriptA.lo g but I don't know how to run scripts 001 through say 108 in order, or how to have them output into one file. Is there a way to use this or something else (like run 001*.sql, then run 001+1*.sql [I have no idea how to program!) so that I can just point it to the folder with the numbered scripts and have them run one by one in order?? Any help is REALLY REALLY appreciated!!!! Thank you
- Next message: Andrew J. Kelly: "Re: Run Multiple Stored Procedures in order with a script??"
- Previous message: Fany Vargas [MSFT]: "RE: Invalid authorization specification"
- Next in thread: Andrew J. Kelly: "Re: Run Multiple Stored Procedures in order with a script??"
- Reply: Andrew J. Kelly: "Re: Run Multiple Stored Procedures in order with a script??"
- Reply: Nigel Rivett: "RE: Run Multiple Stored Procedures in order with a script??"
- Reply: Larry: "Re: Run Multiple Stored Procedures in order with a script??"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
