Create Jobs Automatically when SdtEnableInventory is True - Githubissues

imajaydwivedi / SQLDBATools

Powershell Module containing cmdlets for carrying out SQL DBA activities.

https://ajaydwivedi.com

MIT License

13 stars 6 forks source link

Create Jobs Automatically when SdtEnableInventory is True #31

Open imajaydwivedi opened 2 years ago

imajaydwivedi commented 2 years ago

Kindly automatically create jobs for Monitoring servers if

$SdtEnableInventory is True
$SdtInventoryInstance.$SdtInventoryDatabase has $SdtInventoryTable existing
Warning if the script path is not accessible by SQL Service account
Warning message to configure job with Credential/Proxy if above script path check fails

Also, we below jobs to monitor Inventory Server & Database itself

[ ] Add windows scheduled task for Monitoring SQL Services of Inventory Server
[ ] Add windows scheduled task for Monitoring Inventory database health on Inventory Server

imajaydwivedi commented 2 years ago

Control this feature using another Env variable, say, $SdtCreateMonitoringJobs