(B) create error handling in PS script [in_progress] (B) create baseline capturing [in_progress] (B) create batches per ser / per duration baseline job [in_progress] (C) create exec PS module [working] [in_progress] (C) create execution config (C) create test if already executed within same period frame (check execution history) (C) backup tables : datetime2(7) > datetime2(0) (C) standaard naamgeving [in_progress] (C) execute with or without -AutoCreateTable depending on global switch (C) rework baseline collection code to function (D) create 4 hourly /weekly / monthly jobs (cleanup etc) [in_progress] (E) redo INVT.sqlservers : CX on [ENV] & [SQLinstance] x 2022-12-02 create check backups x 2022-12-03 create check db last used x 2022-12-03 create check connected app x 2022-12-06 clean dubbele data , wegens dubbelle CMS 8327 row, create UX to avoid this x 2022-12-05 create daily job x 2022-12-05 windows task schedular PS job runs for hours , don't use win TS , use SA jobs (likely credentials issue) x 2022-12-06 why can PRD -PC8305\SQLDB be connected but not be automated , CMS issue ? YES : a CMS cannot be a member of a group that it maintains. => move CMS pri:A (A) check backup history , there is an bug in last date calc (see 8258\DB3) (A) create report sql & window errors in logs