The most convenient way to maintain up-to-date Catalog Line Item data is to configure a SQL job to run the spgpm.UpdateCatalogLines procedure automatically. The steps for creating such a job are as follows:
Open SQL Server Management Studio
Connect to your company database
At the bottom of the Object Explorer list, you will see SQL Server Agent. Click the + next to this and right-click the Jobs folder
Right-click on Jobs and select New Job
Enter a name for the job in the window that appears (i.e. Update SalesPad Mobile Catalog DataWarehouse)
Go to the Steps page and create a new Step
Name the Step and create with a type of Transact-SQL script (T-SQL). Select the database as your company database.
In the command text area, type exec spgpm.UpdateCatalogLines
Click on the Schedules page and click New. From here, select the days and options for when the job should run. SalesPad recommends that the job run nightly when users are not in the system.
From this point, you can set up any notifications or alerts. When finished, click OK.