Page Comparison

Open Notepad

Image Added

Type in the following:

sqlcmd -S <ComputerName>\<InstanceName> -i

\\<ServerName>\Workbench\ScheduledJobs\<MyScript.sql> -

...

o 

\\<ServerName>\Workbench\ScheduledJobs\<MyScript.txt>

Image Added

<ComputerName>\<InstanceName> = The SQL Server instance that you want to run this on<ServerName> on

<ServerName> = The Server the Workbench Share is on<MyScripton

<MyScript.sql> = The Name of the .SQL script you created in Create .SQL Scripts<MyScriptScripts

<MyScript.txt> = Is the name of the output file for you to check once competed make it the same name as the .sql except a .txt

Image Added

Save the document into the ScheduledJobs folder as a .bat file