Difference between revisions of "ConnectR SQL Jobs"

From Galen Healthcare Solutions - Allscripts TouchWorks EHR Wiki
Jump to navigation Jump to search
(do not delete my edit thank you.)
 
(4 intermediate revisions by 3 users not shown)
Line 1: Line 1:
=Overview=
+
[[Category:ConnectR|SQL Jobs]]
 +
==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.
 
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==
=Location=
+
*C:\Program Files\IDX Systems Corporation\IDXConnectR v4.6\Updates\DB_Maint_CXR.jobs.only.sql<br>
C:\Program Files\IDX Systems Corporation\IDXConnectR v4.6\Updates\DB_Maint_CXR.jobs.only.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\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
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.
 
 
 
 
 
 
Note - PZummo - Do Not delte.
 
 
Patrick Zummo says
 
i found the files just fine
 
so i wanted to know 1) is there a way to confirm if it's necessary and 2) if so, how to do what is needed
 
Joe Nyiri says
 
ok, so whether or not they are needed
 
go back to SSMS and open the job area
 
you should have 3 connectr jobs here
 
1) backup 2)purge 3)reindex
 
i don't see any of them
 
now you can check, because the backup job may not be needed
 
right click on the connectr DB and go to props
 
this one looks ok, they must have a maintenance plan
 
just look at the DB backup dates basically
 
log should be backed up hourly
 
the full b/u should be done daily, but some clients do it weekly, and it looks like this one is weekly
 
so in order to run the jobs in, go to the directory you have open
 
we're going to do the purge and reindex jobs
 
can you maxmimize this window?
 
scroll down
 
hmmm ok
 
double click the reindex and purge job
 
scroll down more
 
more
 
ok, you are good to run it in
 
Patrick Zummo says
 
just execute?
 
Joe Nyiri says
 
yeah
 
Patrick Zummo says
 
cool
 
Joe Nyiri says
 
now refresh the jobs
 
run that one
 
right click and start job
 
yeah
 
k
 
now find the purge job
 
idxconnectr....
 
yep
 
ok, you're done
 
in the diff versions of cxr, the jobs have different names and stuff
 
Patrick Zummo says
 
ok awesome... so what is the deal? some clients those things get automatically isntalled or set to run and some have to be manually?
 
Joe Nyiri says
 
the backup one needs to be edited usually before running it in
 
yeah, never have figured out why they're not in some envs
 
Patrick Zummo says
 
ok
 
I may update your wiki. I can go through the steps from this IM and maybe add screenshots
 
Joe Nyiri says
 
k
 

Latest revision as of 15:06, 16 November 2012

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.