Updated 04_Agent_Jobs.ps1 - Fixed Asterisks in Jobname, added script out of all jobs to a single file Alljobs.sql

Full Changelog: v2022.04...v2024.06

Added 04_Agent_Configuration.ps1 - SQL Agent configuration settings including the location of the Agent error log file
Added Job Schedule and Duration.pbix - for Visualizing Agent Jobs as a Gantt Chart to show overlaps

Refactored 22 Policy Based Management to use standard SQL instead of SMO

Added back 22_Policy_Based_Mgmt.ps1
Added new security audit script 51_Detailed_Security_Audit.ps1

SQLTranscriptase-2020-05.zip

Updated LoadSQLSMO psm1 module for SMO version 1.60

• Moved SQLSMO into SQLTranscriptase