Page Comparison

Open SQL Server Management Studio and connect to the required SQL Instance

Image Added

Expand the SQL Server Agent

Image Added

Select Jobs and Right mouse click

Image Added

Select New Job

Image Added

Type in the Name of the Job

Image Added

Select Steps

Image Added

Click the New Button

Image Added

Type In the Step Name

Image Added

Change Database name to the Workbench Database you wish this to run on from the drop down List

Image Added

Type the following Statement into the Command Box:

Exec wbapprovalRequired_Send

Image Added

Click OK

Select Schedules

Image Added

Click New and Fill out the form as below

Image Added

Click Ok

Click Ok

Repeat Steps 3 -15 with the following

...

Changes:

• Step 5 Name the job Po Approval

...

• Summary
• Step 8 Name the Step Po/Voucher Approval

...

• Summary
• Step 10 Type this in to the command box Exec wbapprovalRequired_Send 'Summary'

Step 13 Make Sure the form is filled out as below.

Note You can change the day the summary runs to suit your requirements.

Image Added

Change the Control parameter 'SMTP Mail' in the Workbench Database to SQL 2005.