< Back

New-AzureVMSqlServerAutoPatchingConfig

Wed Jan 30, 2019 5:49 pm

NAME New-AzureVMSqlServerAutoPatchingConfig



SYNOPSIS

Creates a configuration object for virtual machine automatic patching.





SYNTAX

New-AzureVMSqlServerAutoPatchingConfig [-Enable] [-DayOfWeek <String>] [-MaintenanceWindowStartingHour <Int32>] [-MaintenanceWindowDuration <Int32>]

[-PatchCategory <String>] [-InformationAction <ActionPreference>] [-InformationVariable <String>] [<CommonParameters>]





DESCRIPTION

The New-AzureVMSqlServerAutoPatchingConfig cmdlet creates a configuration object for virtual machine automatic patching.





PARAMETERS

-Enable [<SwitchParameter>]

Indicates that automated patching for the virtual machine is enabled. If you enable automated patching the cmdlet will put Windows Update into

interactive mode. If you disable automated patching, Windows Update settings will not change.



Required? false

Position? named

Default value False

Accept pipeline input? False

Accept wildcard characters? false



-DayOfWeek <String>

Specifies the day of the week when updates should be installed.



The acceptable values for this parameter are:



-- Sunday



-- Monday



-- Tuesday



-- Wednesday



-- Thursday



-- Friday



-- Saturday



-- Everyday



Required? false

Position? named

Default value None

Accept pipeline input? False

Accept wildcard characters? false



-MaintenanceWindowStartingHour <Int32>

Specifies the hour of the day when maintenance window starts. This time defines when updates start installing and is rounded to the hour.



Required? false

Position? named

Default value None

Accept pipeline input? False

Accept wildcard characters? false



-MaintenanceWindowDuration <Int32>

Specifies the duration of the maintenance window. Automated patching will avoid performing an action that can impact a machine availability outside

of that window. Only 30 minutes increments are allowed.



Required? false

Position? named

Default value None

Accept pipeline input? False

Accept wildcard characters? false



-PatchCategory <String>

Specifies whether important updates should be included.



Required? false

Position? named

Default value None

Accept pipeline input? False

Accept wildcard characters? false



-InformationAction <ActionPreference>





Required? false

Position? named

Default value None

Accept pipeline input? False

Accept wildcard characters? false



-InformationVariable <String>





Required? false

Position? named

Default value None

Accept pipeline input? False

Accept wildcard characters? false



<CommonParameters>

This cmdlet supports the common parameters: Verbose, Debug,

ErrorAction, ErrorVariable, WarningAction, WarningVariable,

OutBuffer, PipelineVariable, and OutVariable. For more information, see

about_CommonParameters (https:/go.microsoft.com/fwlink/?LinkID=113216).



INPUTS



OUTPUTS

AutoPatchingSettings

This cmdlet returns object contains settings for automated patching.





NOTES









-------------------------- Example 1: Create a configuration object to configure automatic patching --------------------------



PS C:\\>$APS = New-AzureVMSqlServerAutoPatchingConfig -Enable -DayOfWeek "Thursday" -MaintenanceWindowStartingHour 11 -MaintenanceWindowDuration 120

-PatchCategory "Important"

Enable : True

DayOfWeek : Thursday

MaintenanceWindowStartingHour : 11

MaintenanceWindowDuration : 120

PatchCategory : Important



This command creates configuration object that can be used to configure automatic patching using Set-AzureVMSqlServerExtension.



RELATED LINKS

Set-AzureVMSqlServerExtension

Remove-AzureVMSqlServerExtension

Set-AzureVMSqlServerExtension