Skip to main content
Question

Execute transformer once a month


sunsilk11
Contributor
Forum|alt.badge.img+6

Hi I have a workspace which does a bunch of queries and inserts and updates an SDE polygon feature class. The workspace is run every 2 minutes.

I have written a shutdown script to rebuilt the indexes using arcpy.RebuildIndexes_management

This command however takes over 2 minutes to run, hence I would like to only run it once a month, say one the first of the month between 12 and 12:30 am.

Any suggestions ?

4 replies

Forum|alt.badge.img

Could you take the shutdown script out of the workspace and run it in a PythonCaller in a seperate workspace which is scheduled using either FME Server or Task Scheduler?

FME Server offers the ability to run using a CRON time as opposed to a regular timed interval.


parashari
Forum|alt.badge.img+2
  • August 9, 2019

You can create a batch file of the workbench and run through task scheduler if you are working on Windows OS.


sunsilk11
Contributor
Forum|alt.badge.img+6
  • Author
  • Contributor
  • August 9, 2019

Thanks. That's an option. I thought there might be a way to use a testfilter and run a python caller on specific date and time.


ebygomm
Influencer
Forum|alt.badge.img+31
  • Influencer
  • August 9, 2019
sunsilk11 wrote:

Thanks. That's an option. I thought there might be a way to use a testfilter and run a python caller on specific date and time.

You could amend your python script so that it retrieved the date then tested if it was in your range and only completed the rest of the script if it passed


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings