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.


    • Related Articles

    • SmartSYNC: Raiser's Edge 7 connector requirements

      If you have Raiser's Edge 7 (RE) self hosted and Blackbaud's REAPI addon then we can connect SmartSYNC for you. You will have a lot but not all the functionality of the product as we have reengineered a subset of the Blackbaud SKY API for RE7. The ...

    • How to send emails from Raiser’s Edge via Outlook, Outlook 365 or OWA

      Raiser's Edge (RE) Database view (through Citrix) When you start RE via Citrix (by going to Blackbaud's website and logging in to launch the Database View of RE) there are no direct email integration options for sending emails. Clicking on an email ...

    • SmartEMAIL: Connecting Gmail / Outlook to Raiser's Edge NXT

      Pick up the emails you wish to record First you need to create the category (in Outlook) or label (in Gmail) which you will apply to emails you wish SmartEMAIL to process. Any emails with this marker will be processed within 5 minutes by SmartSYNC ...

    • SmartMAILCHIMP: Set up and configuration in Mailchimp and Raiser's Edge NXT

      How are Mailchimp and Raiser's Edge kept in sync? SmartMAILCHIMP works by transactional sync, changes are passed between Mailchimp and Raiser's Edge via our SmartSYNC platform as they happen. SmartMAILCHIMP connects a dynamic Constituent List in ...

    • SOLUTION: SmartSOCIAL and the 'LinkedIn refuses to connect' error

      We now have a workaround for this error message. We are talking to Google about a fix to SmartSOCIAL CORE to solve this in the longer term. Currently though you can do the below if you really need to get up and running again. Workaround Install the ...