nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Where should I put my script so it can run at night?

GeoDev

I'm creating a geoprocessing script and was told I should make it run at night when everyone is clocked out by communicating with the database. I haven't done that before so I asked for documentation for help. My supervisor gave me the below script that would allow me to do this; however, I'm confused as to where I am supposed to put my geoprocessing script within this database connection script. Here is the script that is supposed to communicate with the database and allow my script to be run at night:

# import packages
import os, arcpy, time, smtplib
# setup workspace and SDE databases in folder
for dirpath, dirnames, filenames in os.walk(r'//10.0.8.36/GIS/Software/Connection_dir/Test/'😞
for file in dirpath:
print(filenames)
        string = r'//10.0.8.36/GIS/Software/Connection_dir/Test/'
        new_list = [string + x for x in filenames]
print(new_list)
for database in new_list:
# Email users in database(s)
            userList = arcpy.ListUsers(database)
print(userList)
# Block new connections to the database.
            print('The database is no longer accepting connections.format{}'.format(database))
            arcpy.AcceptConnections(database, False)
# Disconnect all users from the database.
            print("Disconnecting all users")
            arcpy.DisconnectUser(database, "ALL")
# Run the compress tool.
            print("Running compress")
            arcpy.Compress_management(database)
# Allow the database to begin accepting connections again
            print("Allow users to connect to the database again")
            arcpy.AcceptConnections(database, True)
# Rebuild indexes in database(s)
            print("Rebuilding indexes on the system tables")
            arcpy.RebuildIndexes_management(database, "SYSTEM")
# Updating statistics in database(s)
            print('Updating statistics on the system tables.format{}'.format(database))
            arcpy.AnalyzeDatasets_management(database, "SYSTEM")
print ("Finished")
break
    break

I'm assuming my geoprocessing script would go after all of the code within the third for loop.

Finde mehr Beiträge mit dem Tag

Accepted answers

All comments

blake.terhune

Schedule a Python script or model to run at a prescribed time: 2019 update (esri.com)

Kara_Shindle

It would, as long as it is indented so as not to be included in any of those for loops.

GeoDev

Thanks for the reply. So are you saying the geoprocessing script should go
after all the above code I posted? if so, wouldn't it not have any
indentation because its going after all the for loop code blocks?

blake.terhune

It depends what your geoprocessing script does. Is it part of database maintenance? That script code you posted is performing database maintenance operations that should all happen together without interference of anything else. However, the logic of that script is strange because the compress operation is in a loop but the unconditional break statement will exit the loop after the first iteration.

A better way to do it is like this where it connects as SDE to perform compress, then does analyze and indexes as owner of the objects (different database connections).

Use Python scripting to batch reconcile and post versions—ArcMap | Documentation (arcgis.com)

Additionally, I found that I needed to use arcpy.SetLogHistory(False) so as not to fill up the geodatabase metadata with this nightly task, which seemed to keep slowing down the performance of the script each time.

GeoDev

The geoprocessing script I need to add to the database script I posted just appends fields of one attribute table to another layer's attribute table, but my supervisor wants it to run at night at a given interval of time (probably once a week).

I don't have any experience on arcpy database maintenance functions and feel timid to write my own database maintenance scripts because of my lack of knowledge in that area. Could you link some beginner friendly resources on how I could learn?

Also, for a quick solution, do you think I can take on my geoprocessing script (basically just table to table, and cursor functions) to the database script I was given, then set a schedule using task scheduler? If so, where should I put the geoprocessing script within the db script?

Thanks for your help!

Nimm an der Diskussion teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.