Search
Close this search box.
How can we help?
< All Topics
Print

How to modify the Datamart refresh schedule

Posted
Updated

The automated refresh schedule for Datamart is setup and managed through a standard “SQL Server Agent Job” accessible through SQL Server Management Studio:

At the time of installation informXL creates a default SQL job called “Update informXL Datamart”, which is scheduled to run nightly at 3:00 am.  When this SQL job executes, all Datamart tables that are “enabled” within the Datamart App are updated in accordance with the app’s specified parameters.

The schedule of this SQL job may be modified to suit specific client needs (i.e., you may change the job to run at 11:00 pm in lieu of 3:00 am), though informXL recommends the Start time be set outside of primary business hours.

In addition to modifying the default “Update informXL Datamart” SQL job, you may also create additional jobs to run updates for specific tables at more frequent intervals.  For assistance or recommended best practices regarding setup of additional and more frequent SQL Jobs, please contact our informXL Support team at [email protected].

Categories
Table of Contents

informXL makes your information your greatest asset.

Since 2009 we’ve helped North America’s fastest-growing builders make smarter, more informed decisions through visual analytics, dashboards, and mobile reporting. Your vision, our information know-how. Let us help you see your business – better.