Microsoft SQL Server: Configuring the import task

To configure the import task in Microsoft SQL Server:

  1. Go to SQL Server Management Studio > SQL Server Agent.

  2. Right-click Jobs and select New Job.

    Location of New Job in Object Explorer.

  3. In the New Job dialog , click General and set the following parameters:

    • Name. HVRI_Import

    • Owner. IEE

    • Category. [Uncategorized (Local)]

    • Description. Enter a meaningful description of this SQL job.

    • Enabled. Select this checkbox to make this job active.

      Location of the Enabled checkbox.

  4. Click Steps.

  5. Click New and set the following parameters:

    • Step name. HVRI_Import_Run

      Note: Create an ARI Import job for each thread. The number of threads is defined in System Settings > AMI Readings Import > Max Threads.

    • Type. Transact SQL Script (T-SQL)

    • Database. ItronEE

      The new job setup dialog.

  6. Click Advanced and set the following parameters:

    • On success action. Quit the job reporting success

    • Retry attempts.0

    • Retry interval (minutes). 0

    • On failure action. Quit the job reporting failure

      The Advanced options dialog.

  7. Click OK.

  8. Click Schedules.

  9. Click New and configure the following parameters:

    • Name. HVRI_Import

    • Schedule type. Recurring

    • Enabled. True (select the checkbox)

    • Occurs. Daily

    • Recurs every. 1 day(s)

    • Occurs every. 1 minute(s)

    • Starting at. 12:00:00 a.m.

    • Ending at. 11:59:59 p.m.

    • Start date. Enter the date you want the import task to start monitoring the import directory for data.

    • No end date. True (select the radio button)

      The Schedules dialog.

  10. Click OK.

Related topics: