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 Agent job collection and auditing #306

Open Adedba opened 1 year ago

Adedba commented 1 year ago

Add Agent job collection and auditing

We cannot do this in real time but we can maintain the current job/schedule information in a table and poll every x minutes and check for changes then update the table. Old values from the table will get inserted into an audit table.