The process of refreshing the data shared between MoversSuite and Microsoft Dynamics GP can be automated through job scheduling within Microsoft SQL Server Management.   Running the BUILD_GP_WAREHOUSE job will perform the same tasks that is manually performed by the Refresh Data function in Data Warehouse Refresh.

 

Important: The SQL Server Agent service must be activate and running on the SQL Server in order for the job scheduling feature to work.   The SQL Server Agent icon indicates whether the services is running () or not.

 

In Microsoft SQL Server Management, the MoversSuite provided job is located within the database hierarchy under SQL Server Agent > Jobs.

 

Figure 64: Microsoft SQL Server Management Studio

 

By default, the BUILD_GP_WAREHOUSE job is scheduled to run daily at midnight.   This can be updated through the Properties window available by double-clicking the job name or by right-mouse clicking the job name.  Specifically, from the Properties screen, select Schedules and then Edit to view and change the job scheduling properties.

 

Figure 65: Job Schedule Properties screen