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.
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
Note - PZummo - Do Not delete.
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