SQLUndercover / UndercoverToolbox

A collection of cool and useful tools, procedures and scripts for the discerning DBA
https://sqlundercover.com
MIT License
84 stars 40 forks source link

Inspector - Add WasSuccessful flags for Reports and Modules tables #304

Open Adedba opened 1 year ago

Adedba commented 1 year ago

Add WasSucccessful column to ModuleConfig and Modules tables and have the Inspector update these columns with the outcome of individual module collections and reports to flag whether they succeeded or failed.

We already log to the executionlog however this can be handy to see whilst you are looking in these tables too as you may not look at the executionlog table much unless you have a reason to do so.