topic Can we run the python script to update statistics as standalone program ? in Developers Questions

Can we run the python script to update statistics as standalone program ?

RaymondCao — Tue, 04 Dec 2018 20:01:45 GMT

Hi Everyone,

I am new to this forum. My first question is:

Can we run the python script to update statistics as standalone program without ArcGIS Pro desktop?

Here is our situation.

ESRI provides a python script to update statistics in geodatabases:

https://pro.arcgis.com/en/pro-app/help/data/geodatabases/manage-sql-server/update-statistics.htm

We like to run this script on a single computer for all users and also geodatabases admin automatically every day at not-busy time. This script uses ArcPy python library, I just like to know if ArcGIS pro desktop has to be installed on this computer or we can run this python script with ArcPy standalone.

Thank you.

Raymond

Re: Can we run the python script to update statistics as standalone program ?

DanPatterson_Retired — Tue, 04 Dec 2018 20:06:11 GMT

The key phrase is 'scheduled task'

Python in ArcGIS Pro—ArcPy Get Started | ArcGIS Desktop

there is a small example in the link

Re: Can we run the python script to update statistics as standalone program ?

RaymondCao — Tue, 04 Dec 2018 20:20:17 GMT

Thank you for the fast comment.

Yes, I read the script example in the link. The script uses ArcPY. Do I have to install ArcGIS Pro desktop on the computer before I can run the python script with ArcPy or I can run it without installing ArcGIS Pro desktop?

Re: Can we run the python script to update statistics as standalone program ?

DanPatterson_Retired — Tue, 04 Dec 2018 20:22:57 GMT

If your script uses anything rooted in ArcGIS pro … including arcpy... then yes. Otherwise it is just a general python question

Re: Can we run the python script to update statistics as standalone program ?

JoeBorgione — Tue, 04 Dec 2018 20:23:35 GMT

My agency runs the full database compress, analyze, statistics every week for all of our enterprise geodatabases as a scheduled task. The server on which the scripts execute has ArcGIS 10.5.1 installed and is licensed like any other user through our license server.

We have ArcGIS Pro installed on desktop computers only and are currently using it only as a desktop application, not for administration. The key to running stand alone arcpy scripts is having arcpy (aka some flavor of ArcGIS) installed on the computer executing the scripts. Remember, for database administration, you'll need database administration privileges.