99. Agent Upgrades.md

Agent Upgrade Management

Get Agents with Upgrade available

Get-PPDMagents -updateState AVAILABLE

Schedule Update Precheck for all MSSQL Agent

Get-PPDMagents -type MSSQL -updateState AVAILABLE | Set-PPDMagents_update_sessions -precheckOnly -scheduledAt 16:00
Get-PPDMagents_update_sessions -state SCHEDULED

Delete all Scheduled Update Precheck Sessions

Get-PPDMagents_update_sessions -state SCHEDULED | Remove-PPDMagents_update_sessions

Adhoxc run a Precheck

Get-PPDMagents -type MSSQL -updateState AVAILABLE | Set-PPDMagents_update_sessions -precheckOnly -Name PrecheckNow

id           : 4812ea00-3018-4e1c-831a-09f588903e35
name         : PrecheckNow
precheckOnly : True
hosts        : {@{id=ba9bcb41-6c6c-435c-8468-39af78f21ddd; appServerTypes=System.Object[]}}
state        : SCHEDULED
Get-PPDMagents_update_sessions -id 4812ea00-3018-4e1c-831a-09f588903e35

Run an Adhoc Update, Specifying what Package to use

Get-PPDMagents -type MSSQL -updateState AVAILABLE | Set-PPDMagents_update_sessions -type 'Microsoft Application SQL Agent' -Name UpdateNow
Get-PPDMagents_update_sessions