osql -S [MyServer] -d [MyDatabase] -E -i ["C:\Test\SQLScriptProcedure.sql"] -n -b
Create a SQL Script file SQLScriptProcedure.sql as shown below..
declare @StartDate datetime set @StartDate=getdate()-30
declare @EndDate datetime set @EndDate=GETDATE()
exec SP_Name @StartDate,@EndDate
Use the following snippet to write a log..
osql -S [MyServer] -d [MyDatabase] -E -i ["C:\Test\SQLScriptProcedure.sql"] -n -b -o [Output.log]
Use the following snippet to execute multiple SQL script files
for %%f in (*.sql) do
(
osql -S [MyServer] -E -d [MyDatabase] -i %%f >> [Output.log]
)
pause