From June 6, 2022 to August 12, 2022, I was an intern with the government of Navajo County, Arizona. Over the course of this internship, I was assigned to write internal tools for the Programming division of their IT department. Several of these projects were written in languages I was assigned to learn specifically for the tasks at hand.
SQL Server Agent Jobs Schedule
For my first assignment, I was assigned to create a PowerShell script that would query each SQL Server instance for the list of Agent Jobs running, their time started, a calculated average of the last 10 run durations, the day scheduled, and the job's last run status. A second PowerShell script would create an Excel spreadsheet for each day showing the time each job starts and finishes.
This project was later expanded to collect information about the Windows Server instances on which the server ran, and their statuses and last updates after polling the server for its agent jobs.
Over the course of this project, I learned about the operations of Microsoft SQL Server, the T-SQL language, T-SQL stored procedures, and the PowerShell language.
ArcGIS Online Automatic Map Refresh
I was then assigned to create a tool to regenerate various maps in the county's ArcGIS Online system. The project was written in Python using the ArcGIS Python libraries. The tool would generate a PDF from the map's definition file, and then upload it to the ArcGIS Online portal.