Raiser's Edge: Install a T-SQL based solution to run automatically

Raiser's Edge: Install a T-SQL based solution to run automatically

We sometimes provide solutions for Raiser's Edge based upon REOpen/T-SQL technology. These are installed to run automatically on a timed basis on your Raiser's Edge database server. To do this you will need your RE Database Administrators to follow the below process. Please provide them with the script we have supplied you with and a link to this page.

To install you use SQL Management Studio to connect to your Raiser's Edge database server and then install a SQL Server Agent job as below:
  1. Expand the SQL Server Agent node and right click the Jobs node in SQL Server Agent and select 'New Job'
  2. In the 'New Job' window enter the name of the job and a description on the 'General' tab i.e. 'SmartTHING SQL Job'
  3. Select 'Steps' on the left hand side of the window and click 'New' at the bottom.
  4. In the 'Steps' window enter a step name and select the Raiser's Edge database i.e. 're7'.
  5. Paste in the T-SQL command we have supplied into the Command window and click 'OK'.
  6. Click on the 'Schedule' menu on the left of the New Job window and enter the schedule information (e.g. daily and a time). See our instructions for the suggested frequency.
  7. Click 'OK' - and that should be it.