Rodney Matejek
Repoting Analyst | Data Analyst | Technical Writer| SQL Developer
Creating simple solutions from complex business requirements
Building a table that monitors execution of stored procedures, and records the status of the process both while executing and after completion
Description of what is saved in the monitoring table
A picture showing precise detail saved in the process monitoring table
Execution monitoring process
Our CIITS data feed was of such importance that we needed a means of knowing the exact status of execution of the complete process. To do this, I added code that would insert into a control table the data that I thought would be most helpful to know in the case of a problem with the data feed. Since this process would loop through 176 school districts within Kentucky, I decided that we would need the following information.
1. The process being executed.
2. The exact time that it started to run.
3. The exact time that I queried the table.
4. The school district being processed at the time of the query being run.
5. A message whether or not the job completed, is still running, or encountered an error during execution. In the case of an error, the complete error code and message.