I have a scheduled workspace that needs to truncate an sde table. The table is shared as aservice in AGS and portal. I see a customtransformer to start/stop the arcgisserver.
But if i'm not mistaken this would not remove any locks that are on the sde table.
do i need to put this into an automation in order to make all this happen? since i don't see any specific transformers to accomplish this. is it going to have to be through the rest api or python? does anyone have a workflow and or script to do this?
I assume i would need to...
- stop the AGS service (to keep someone from connecting while the rather lengthy trunc/load is happening)
- then remove the locks (I think i have only heard of doing this through the rest api).
- run the fme wkspc and truncate then load the new data.
- restart the service.