Note: Due to the support transition of The Patron Edge, The Patron Edge Online, and The Patron Edge Kiosk to TopTix Support, Blackbaud is no longer actively updating these solutions. For the most up-to-date information, visit support.toptix.com to review their Knowledgebase.

Note:
 We recommend creating this job on The Raiser's Edge server. Running SQL jobs requires that SQL Server Agent be running. Read more information on using SQL Server Agent. 

  1. On the server that runs the integration, open SQL Server Management Studio.
  2. Connect to the appropriate SQL Server instance.
  3. Expand SQL Server Agent.
  4. Right-click on Jobs and select New Job.
  5. On the General Tab enter the Name of the job as Patron Edge Interface and mark the Enabled checkbox.
  6. In the Owner drop-down list, select an owner who has System Administrator rights (e.g. the sa account).
  7. Enter an appropriate description if desired.
  8. Select the Steps tab and click New.
  9. For the Step name, enter Synchronize.
  10. For the Type drop-down list, select Operating System Command(CMDExec).
  11. In the Command field, enter the following line:
     
    • "[Path to PE folder]\The Patron Edge\PEInterface.exe" /d[db number]

      For example, "C:\Program Files\Blackbaud\The Patron Edge\PEInterface.exe" /d2 

      * Where [db number] is the number of The Patron Edge database that should be integrated, according to the order they appear when launching Patron Edge.

     
  12. Click OK.
  13. Select the Schedules tab and click New Schedule.
  14. Enter Patron Edge Interface in the Name field.
  15. In the Schedule type drop-down list, select Recurring and mark the adjacent Enabled checkbox.
  16. In the Occurs drop-down list, select Daily and Recurs every 1 Day.
  17. Select the appropriate Daily frequency, for example: Occurs every 10 Minute(s) Starting at 8:00:00 AM and Ending at 6:00PM.
  18. In the Duration section, set Start date to the current date and select No end date.
  19. Click OK.
  20. Select the Notifications tab and select the appropriate option if you would like to be notified when this is run.
  21. Mark the Write to Windows application event log checkbox and select Whenever the job completes.
  22. Click OK.
  23. Right click on the newly created job and select Start Job. This will start the initial job run. All subsequent runs will be automatically processed.
  24. Right-click on My Computer and select Management to view the Application Event log under Event Viewer to view if the job completed successfully.