Create the Batch file to schedule

Owned by Former user (Deleted)
Last updated: Jul 06, 2012
1 min read

Open Notepad

Type in the following:

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

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

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

 

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

<ServerName> = The Server the Workbench Share is on

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

<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

 

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