Set up Procedure

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

 

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 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.

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