Thank you for your feedback.
Form temporarily unavailable. Please try again or contact docfeedback@servicenow.com to submit your comments.
Versions
  • Madrid
  • London
  • Kingston
  • Jakarta
  • Istanbul
  • Helsinki
  • Geneva
  • Store
Close

Schedule a data import

Log in to subscribe to topics and get notified when content changes.

Schedule a data import

Scheduled imports make it is possible to specify that certain import operations should occur at some regular interval.

Before you begin

Role required: import_scheduler, import_admin, or admin

About this task

Warning: Do not schedule multiple imports at the same time. Running multiple imports at the same time may negatively impact performance or cause an instance outage.

Procedure

  1. Navigate to System Import Sets > Administration > Scheduled Imports.
  2. Complete the form.
    Table 1. Scheduled Data Import form
    Field Description
    Name Name for the scheduled data import.
    Data source Data source record that defines the data to import.

    If you select a remote data source, it is refreshed via the remote connection before the import begins.

    Run as Name of a user whose credentials the import job uses. If you do not specify a value, the import job runs as the guest user.
    Active Check box to activate the scheduled import.
    Run Frequency at which you want to run the import.
    Day Day on which to run the import. Visible only if you set Run to Weekly or Monthly.
    Time Time you want the import to begin. Do not schedule multiple imports at the same time. Running multiple imports at the same time may negatively impact performance or cause an instance outage.
    Repeat interval Period that must elapse before the import is repeated. Visible only if you set Run to Periodically.
    Starting Date on which the import should begin (selected using the calendar icon). Visible only if you set Run to Periodically.
    Parent The parent import set to which this import set belongs, and after which this import should run. Visible only if you set Run to After Parent Runs.
    Conditional Check box to specify a script that defines the conditions that must evaluate to true before the import runs.
    Condition Script that evaluates whether an import should run. Visible only if you select the Conditional check box.
    Concurrent Import Check box to run a concurrent import. A concurrent import splits the data into multiple import sets and runs the import sets concurrently to reduce processing time for large data sets.
    Note: A concurrent import does not transform data in a predictable order. If order matters, do not run a concurrent import.

    For more information, see Concurrent imports.

    Partition Method Method used to allocate each data set record to an import set:
    • Round Robin: The system sets partitions automatically.

      Assume 20 records and 4 import sets. The system allocates record 1 to import set 1, record 2 to import set 2, record 3 to import set 3, record 4 to import set 4; then allocates record 5 to import set 1, record 6 to import set 2, record 7 to import set 3, and record 8 to import set 4; and continues until all records are assigned to import sets.

      When allocation is finished, import set 1 contains records 1, 5, 9, 13, 17; import set 2 contains records 2, 6, 10, 14, 18; import set 3 contains records 3, 7, 11, 15, and 19; and import set 4 contains records 4, 8, 12, 16, and 20.

    • Custom Script: Sets the partitions with a Partition Script you provide.
    Partition Script Script to return a partition key. The system ensures that data set rows with the same partition key go to the same import set.

    Visible only if you set Partition Method to Custom Script.

    Execute pre-import script Check box to specify a script to run before the import is performed.
    Pre script Script to run before the data is imported. Visible only if you select the Execute pre-import script check box.
    Execute post-import script Check box to specify a script to run after the import is performed.
    Post script Script to run after the import is performed. Visible only if you select the Execute post-import script check box.
    Note: For concurrent imports, the script runs after the last Import Set Transformer job completes.
  3. Click Submit.
To stop an import that is taking too much time, navigate to System Import Sets > Advanced > Progress.
  1. Open the Progress Worker that must be canceled.
  2. In the Related Links, click Cancel job.
Feedback