Setup Procedure

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

CREATE .SQL SCRIPTS

Open SQL Server Management Studio

Select New Query

In the Query Window Type the follow:

  • Use <Workbench Database Name>
  • Exec <Stored Procedure Name> <Any Required Parameters> 
  • The Items inside < > must be changed to match your requirements. Note that you can run more than "Stored Procedure" that need to be on the same schedule, you just need to put a "go" on the line directly after the exec statement.

 

Select File-Save Navigate to the Workbench Share and create a new folder called "ScheduledJobs"

Select File-Save Navigate to the Workbench Share and create a new folder called Scheduled Jobs

Name the .SQL file something descriptive and click Save

Repeat these steps for all the Jobs you wish to create.