Schedule a Spatial ETL Tool

PaulSchneider — Thu, 01 Sep 2011 13:02:31 GMT

I have an ETL tool that converts a SDE feature dataset into a Microstation V8 file. I would like it to run automatically on a weekly basis. What is the easiest way to go about this?

Thanks!

Re: Schedule a Spatial ETL Tool

BruceHarold — Fri, 02 Sep 2011 15:50:17 GMT

Hi Paul

Run your ETL tool and from the results window right click the result and copy it as a Python snippet.
Then create a standalone Python script that imports arcpy and imports the toolbox, before executing the snippet, like:

import arcpy
arcpy.ImportToolBox(r'C:\Temp\NEARBug.gdb\NEARBug')
arcpy.SpatialETLTool("'C:/Work/Product Management/Loqate/Loqate.gdb'","geodatabase")

Then follow the directions here to make the script a scheduled task:

http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//002100000038000000.htm

Regards

topic Schedule a Spatial ETL Tool in Data Management Questions

Schedule a Spatial ETL Tool

Re: Schedule a Spatial ETL Tool