Schedule a Spatial ETL Tool

1921
1
09-01-2011 06:02 AM
PaulSchneider
Occasional Contributor
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!
0 Kudos
1 Reply
BruceHarold
Esri Regular Contributor
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
0 Kudos