Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

  1. Open SQL Server Management Studio and connect to the required SQL Instance
  2. Expand the SQL Server Agent
  3. Select Jobs and Right mouse click
  4. Select New Job
  5. Type in the Name of the Job
  6. Select Steps
  7. Click the New Button
  8. Type In the Step Name






  1. Change Database name to the Workbench Database you wish this to run on from the drop down List
  2. Type the following Statement into the Command Box Exec wbapprovalRequired_Send
  3. Click OK
  4. Select Schedules
  5. Click New and Fill out the form as below
  6. Click Ok
  7. Click Ok
  8. Repeat Steps 3 -15 with the following ChangesStep 5 Name the job Po Approval SummaryStep 8 Name the Step Po/Voucher Approval SummaryStep 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.
  9. Change the Control parameter 'SMTP Mail' in the Workbench Database to SQL 2005
  • No labels