Need the code or model to auto compress SDE database, rebuild indexes, analyze datasets & reboot once completed

HunterGwynn — Wed, 11 Mar 2015 13:34:01 GMT

Hello,

I'm using ArcGIS 10.1 & I'm trying to figure out the code or model to auto compress SDE database, rebuild indexes, analyze datasets & reboot once completed. Here's a breakdown:

Compress:
MGSC Prod gis.sde (Wait for process to complete)

Rebuild
Indexes: MGSC Prod gis.sde (Wait for process to complete)

Analyze
Datasets: MGSC Prod gis.sde (Wait for process to complete)

Reboot :PMOBGIS06 (Wait 5 Minutes)

Reboot :PMOBGIS05

(Process complete)

Thanks for you help

Hunter

Re: Need the code or model to auto compress SDE database, rebuild indexes, analyze datasets & reboot once completed

George_Thompson — Wed, 11 Mar 2015 17:48:21 GMT

Hi Hunter,

Here is some code that you could use for the ArcPy operations that you are requesting.

Using Python scripting to batch reconcile and post versions

As for rebooting the machine, you may want to consult with the OS manual.

Hope this will get you going in the right direction......

-George

Geodatabase

topic Re: Need the code or model to auto compress SDE database, rebuild indexes, analyze datasets & reboot once completed in Data Management Questions

Need the code or model to auto compress SDE database, rebuild indexes, analyze datasets & reboot once completed

Re: Need the code or model to auto compress SDE database, rebuild indexes, analyze datasets & reboot once completed