Skip To Content

Schedule Spatial ETL tools on a server

Available with Data Interoperability license.

Spatial ETL (extract, transform, load) tools shared to ArcGIS Server can be run immediately or scheduled to run at a later time or with recurrence. Scheduling a Spatial ETL tool allows you to do the following:

  • Automate a tool you need to run regularly.
  • Run a long-running or computationally intensive process at a convenient, specified time when you will not be using the machine for other tasks.
  • Run multiple Spatial ETL tools concurrently.

Prerequisites

Before you schedule a Spatial ETL tool on an ArcGIS Server machine, ensure the following prerequisites are met:

  • The tool's workspace source is an external .fmw file, and the file is copied to the machine.
  • Linked transformers used by the tool are embedded with the tool.
  • The tool's input and output parameters include format support and are accessible to the machine.
  • FME packages required by the tool are installed on the machine.
  • Web connections used by the tool are imported to the machine.
    Note:

    For instructions on installing FME packages on and importing web connections to an ArcGIS Server machine, see Share Spatial ETL tools.

Schedule Spatial ETL tools

Once you meet all the prerequisites, complete the following steps to schedule a Spatial ETL tool on an ArcGIS Server machine:

  1. Sign in to the ArcGIS Server machine where you want to schedule the Spatial ETL tool using the ArcGIS Server account.
  2. Open the .fmw workspace file in the Workbench application.

    The Workbench application can be found in the directory where you installed the ArcGIS Data Interoperability server extension: <ArcGIS Data Interoperability server extension installation directory>\Data Interoperability\Data Interoperability AO11\fmeworkbench.exe

  3. Review the workspace canvas to ensure it includes the FME packages and web connections used by the tool.
  4. Click the Run button on the toolbar to run the tool.
  5. When the tool has been run, open the Translation Log and locate the syntax to run the workspace from the command line.

    An example syntax is demonstrated below:

    <ArcGIS Data Interoperability server extension installation directory>\Data Interoperability\Data Interoperability AO11\fme.exe" "<path to the workspace file>"..."<parameters>

  6. Set up Windows Task Scheduler to run the workspace as a regular recurrence.