Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Current »

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

 

  • No labels