Skip To Content

Creating batch validation scheduler tables in your enterprise database

Note:

ArcGIS Enterprise 10.9.x, part of the ArcGIS 2021 releases, will be the last release of ArcGIS Enterprise to support services published from ArcMap. You are encouraged to migrate automated review workflows to Data Reviewer capabilities available in attribute rules.

The ArcGIS Data Reviewer ArcMap runtime-based server object extension (SOE) 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 File Open.
  5. Navigate to the location of the tables_sqlServer.sql file.

    This file is located in <ArcGIS server installation 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.

    Example: USE [drs_scheduler]

  8. Click Execute to run the SQL statements.

    The scheduler tables are created in the database.