Creating batch validation scheduler tables in your enterprise database

ArcGIS Data Reviewer Server allows you to schedule batch validation to execute repeatedly according to a schedule. Schedules are stored in a database. By default, ArcGIS Data Reviewer Server uses SQLite to store and manage its schedules. However, you can store the scheduler tables in SQL Server, PostgreSQL or Oracle. If you choose to store the scheduler tables in one of these databases, you must manually create these tables using the process described below.

Note:

These steps are optional. You only need to perform these steps if you want to store your scheduler tables in SQL Server, PostgreSQL or Oracle. The following process pertains to Microsoft SQL Server only.

1. Open Microsoft SQL Server Management Studio.
2. On the Connect to Server dialog box, perform the following steps:
   1. Click the Server type drop-down arrow and choose Database Engine.
   2. Click the Server name drop-down arrow and choose a server that will store the scheduler tables.
   3. Click the Authentication drop-down arrow and choose an authentication type.
3. Click Connect.
4. On the main menu, click the Open File button .
5. Navigate to the location of the tables_sqlServer.sql file.

   This file is located in <ArcGIS server install folder>\ArcGISDataReviewerServer\Server<version>\sql\creation_scripts.

6. Click Open.

   The contents of the file load into the query window.

7. At the top of the file, change [enter_db_name_here] to the name of the database that will store the scheduler tables.

   use [drs_scheduler]

8. Click Execute to run the SQL statements.

   The scheduler tables are created in the database.