Difference between revisions of "ConnectR SQL Jobs"

From Galen Healthcare Solutions - Allscripts TouchWorks EHR Wiki
Jump to navigation Jump to search
Line 6: Line 6:
 
C:\Program Files\IDX Systems Corporation\IDXConnectR v4.6\Updates\DB_Maint_CXR.sql<br>
 
C:\Program Files\IDX Systems Corporation\IDXConnectR v4.6\Updates\DB_Maint_CXR.sql<br>
 
C:\Program Files\IDX Systems Corporation\IDXConnectR v4.6\Updates\backup.sql<br>
 
C:\Program Files\IDX Systems Corporation\IDXConnectR v4.6\Updates\backup.sql<br>
 +
C:\Program Files\IDX Systems Corporation\IDXConnectR v4.6\Updates\reindex and purge job.sql

Revision as of 19:49, 19 December 2011

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