ConnectR SQL Jobs

From Galen Healthcare Solutions - Allscripts TouchWorks EHR Wiki
Jump to navigation Jump to search

Overview

The ConnectR SQL Jobs perform DB maintenance including re-indexing as well as message log purge and database backup. They are typically deployed by the ConnectR installer.

Location

  • C:\Program Files\IDX Systems Corporation\IDXConnectR v4.6\Updates\DB_Maint_CXR.jobs.only.sql
  • C:\Program Files\IDX Systems Corporation\IDXConnectR v4.6\Updates\DB_Maint_CXR.sql
  • C:\Program Files\IDX Systems Corporation\IDXConnectR v4.6\Updates\backup.sql
  • C:\Program Files\IDX Systems Corporation\IDXConnectR v4.6\Updates\reindex and purge job.sql
    • This script installs the ConnectR Reindex ConnectR job and the IDXConnectR4_6 Purge_ConnectR job.