Previous Topic

Next Topic

Inhoudsopgave

Book Index

Scheduled job for updating the RowCount

For the synchronization of the mobile devices, the number of records to be synchronized for each table must be known. A scheduled job is available to determine this information and to update the count on a regular basis. To install this scheduled job:

  1. Start SQL Server Management Studio.
  2. Open the script Create_job_UpdateSyncRowCount.sql that was installed in the specified folder by the Isah Mobile Script installer.
  3. Replace <DatabaseName> in the script by the name of the database.
  4. Change the time if necessary (@active_start_time).
  5. Run the script to create the scheduled job. The scheduled job updates the number of records to be synchronized at the time specified.