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

Expand the SQL Server Agent

Select Jobs and Right mouse click

Select New Job

Type in the Name of the Job

Select Steps

Click the New Button

Type In the Step Name

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

Type the following Statement into the Command Box:

Exec wbapprovalRequired_Send

Click OK

Select Schedules

Click New and Fill out the form as below

Click Ok

Click Ok

Repeat Steps 3 -15 with the following Changes:

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

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

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

Browser not supported