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

Version 1 Next »

  1. Open Notepad
  2. 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

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


  • No labels