Setup Procedure.

Create .SQL Scripts

1. Open SQL Server Management Studio
2. Select New Query
3. In the Query Window Type the follow Use <Workbench Database Name> Exec <Stored Procedure Name> <Any Required Parameters> *** NB ** The Items inside < > must be changed to match your requirements. Also 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.*
4. Select File-Save Navigate to the Workbench Share and create a new folder called ScheduledJobs
5. Select File-Save Navigate to the Workbench Share and create a new folder called Scheduled Jobs
6. Name the .SQL file something descriptive and click Save
7. Repeat these steps for all the Jobs you wish to create.