Using ArcGIS Dashboards To Monitor Scheduled Python Geoprocessing Scripts
Pima County ITD-GIS
Monitoring Scheduled Python Jobs
AdvisorSanchez Trigueros, Fernando
MetadataShow full item record
PublisherThe University of Arizona.
RightsCopyright © is held by the author. Digital access to this material is made possible by the University Libraries, University of Arizona. Further transmission, reproduction or presentation (such as public display or performance) of protected items is prohibited except with permission of the author.
Collection InformationThis item is part of the MS-GIST Master's Reports collection. For more information about items in this collection, please contact the UA Campus Repository at firstname.lastname@example.org.
AbstractThere is a need in Pima County’s Information Technology Department, Geographic Information Systems Division for visualizing the status of GIS scheduled Python jobs that run on various servers throughout the day and night. Most scheduled job owners get notified if there is a problem with the script. However, end users of the data may not necessarily be notified that the data they are viewing did not update. This leads to the end users being perplexed on why their edits made the day before are not visible. The solution was to create a Python module called PC_Monitor that the script owner imports into the beginning of an existing or new script that is executed at the end of the script in either its own try, except statement or at the end of a finally statement. Parameters need to be passed into one of the module’s functions to successfully update the database table. The database table is then used for visualizing the status of the script using ArcGIS Dashboards widgets. The module captures various information programmatically using user inputs. Most importantly, the module captures and records the status of the script (Success, Finished with Warnings, or Failed) and the first 255 characters of the status message for Finished with Warnings and Failed. The module has been successful in various test situations on multiple servers. The PC_Monitor module alongside the ArcGIS Dashboard will help our organization’s GIS users to visually monitor the status of Python scripts, keep track of Python scripts, and the effect those scripts have on data sets.