< Back
Set-AzureRmSqlDatabaseAdvisorAutoExecuteStatus
Post
NAME Set-AzureRmSqlDatabaseAdvisorAutoExecuteStatus
SYNOPSIS
Modifies auto execute status of an Azure SQL Database Advisor.
SYNTAX
Set-AzureRmSqlDatabaseAdvisorAutoExecuteStatus [-ResourceGroupName] <String> -AdvisorName <String> -AutoExecuteStatus {Enabled | Disabled |
Default} -DatabaseName <String> [-DefaultProfile <IAzureContextContainer>] -ServerName <String> [-Confirm] [-WhatIf] [<CommonParameters>]
DESCRIPTION
The Set-AzureRmSqlDatabaseAdvisorAutoExecuteStatus cmdlet modifies the auto execute property for an Azure SQL Database Advisor. Currently, this
cmdlet supports the values Enabled, Disabled, and Default.
PARAMETERS
-AdvisorName <String>
Specifies the name of the advisor for which this cmdlet modifies the status.
Required? true
Position? named
Default value None
Accept pipeline input? True (ByPropertyName)
Accept wildcard characters? false
-AutoExecuteStatus <AdvisorAutoExecuteStatus>
Specifies the value for the status. The acceptable values for this parameter are:
- Enabled
- Disabled
- Default
Required? true
Position? named
Default value None
Accept pipeline input? True (ByPropertyName)
Accept wildcard characters? false
-DatabaseName <String>
Specifies the name of the database for which this cmdlet modifies status.
Required? true
Position? named
Default value None
Accept pipeline input? True (ByPropertyName)
Accept wildcard characters? false
-DefaultProfile <IAzureContextContainer>
The credentials, account, tenant, and subscription used for communication with azure
Required? false
Position? named
Default value None
Accept pipeline input? False
Accept wildcard characters? false
-ResourceGroupName <String>
Specifies the name of the resource group of the server that contains this database.
Required? true
Position? 0
Default value None
Accept pipeline input? True (ByPropertyName)
Accept wildcard characters? false
-ServerName <String>
Specifies the name of the server for the database.
Required? true
Position? named
Default value None
Accept pipeline input? True (ByPropertyName)
Accept wildcard characters? false
-Confirm [<SwitchParameter>]
Prompts you for confirmation before running the cmdlet.
Required? false
Position? named
Default value False
Accept pipeline input? False
Accept wildcard characters? false
-WhatIf [<SwitchParameter>]
Shows what would happen if the cmdlet runs. The cmdlet is not run.
Required? false
Position? named
Default value False
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 (http://go.microsoft.com/fwlink/?LinkID=113216).
INPUTS
None
This cmdlet does not accept any input.
OUTPUTS
Microsoft.Azure.Commands.Sql.Advisor.Model.AzureSqlDatabaseAdvisorModel
This cmdlet returns an AzureSqlDatabaseAdvisorModel object.
NOTES
Example 1: Enable auto execute for an advisor
PS C:\\>Set-AzureRmSqlDatabaseAdvisorAutoExecuteStatus -ResourceGroupName "ContosoRunnersProd" -ServerName "runner-australia-east" -DatabaseName
"ContosoRunner" -AdvisorName "CreateIndex" -AutoExecuteStatus Enabled
DatabaseName : ContosoRunner
ResourceGroupName : ContosoRunnersProd
ServerName : runner-australia-east
AdvisorName : CreateIndex
AdvisorStatus : GA
AutoExecuteStatus : Enabled
AutoExecuteStatusInheritedFrom : Database
LastChecked : 8/1/2016 2:36:47 PM
RecommendationsStatus : Ok
RecommendedActions : {}
This command changes the auto execute status of an advisor named CreateIndex to Enabled.
RELATED LINKS
Online Version: https://docs.microsoft.com/en-us/powers ... cutestatus
Get-AzureRmSqlDatabaseAdvisor
SQL Database Documentation https://docs.microsoft.com/azure/sql-database/
SYNOPSIS
Modifies auto execute status of an Azure SQL Database Advisor.
SYNTAX
Set-AzureRmSqlDatabaseAdvisorAutoExecuteStatus [-ResourceGroupName] <String> -AdvisorName <String> -AutoExecuteStatus {Enabled | Disabled |
Default} -DatabaseName <String> [-DefaultProfile <IAzureContextContainer>] -ServerName <String> [-Confirm] [-WhatIf] [<CommonParameters>]
DESCRIPTION
The Set-AzureRmSqlDatabaseAdvisorAutoExecuteStatus cmdlet modifies the auto execute property for an Azure SQL Database Advisor. Currently, this
cmdlet supports the values Enabled, Disabled, and Default.
PARAMETERS
-AdvisorName <String>
Specifies the name of the advisor for which this cmdlet modifies the status.
Required? true
Position? named
Default value None
Accept pipeline input? True (ByPropertyName)
Accept wildcard characters? false
-AutoExecuteStatus <AdvisorAutoExecuteStatus>
Specifies the value for the status. The acceptable values for this parameter are:
- Enabled
- Disabled
- Default
Required? true
Position? named
Default value None
Accept pipeline input? True (ByPropertyName)
Accept wildcard characters? false
-DatabaseName <String>
Specifies the name of the database for which this cmdlet modifies status.
Required? true
Position? named
Default value None
Accept pipeline input? True (ByPropertyName)
Accept wildcard characters? false
-DefaultProfile <IAzureContextContainer>
The credentials, account, tenant, and subscription used for communication with azure
Required? false
Position? named
Default value None
Accept pipeline input? False
Accept wildcard characters? false
-ResourceGroupName <String>
Specifies the name of the resource group of the server that contains this database.
Required? true
Position? 0
Default value None
Accept pipeline input? True (ByPropertyName)
Accept wildcard characters? false
-ServerName <String>
Specifies the name of the server for the database.
Required? true
Position? named
Default value None
Accept pipeline input? True (ByPropertyName)
Accept wildcard characters? false
-Confirm [<SwitchParameter>]
Prompts you for confirmation before running the cmdlet.
Required? false
Position? named
Default value False
Accept pipeline input? False
Accept wildcard characters? false
-WhatIf [<SwitchParameter>]
Shows what would happen if the cmdlet runs. The cmdlet is not run.
Required? false
Position? named
Default value False
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 (http://go.microsoft.com/fwlink/?LinkID=113216).
INPUTS
None
This cmdlet does not accept any input.
OUTPUTS
Microsoft.Azure.Commands.Sql.Advisor.Model.AzureSqlDatabaseAdvisorModel
This cmdlet returns an AzureSqlDatabaseAdvisorModel object.
NOTES
Example 1: Enable auto execute for an advisor
PS C:\\>Set-AzureRmSqlDatabaseAdvisorAutoExecuteStatus -ResourceGroupName "ContosoRunnersProd" -ServerName "runner-australia-east" -DatabaseName
"ContosoRunner" -AdvisorName "CreateIndex" -AutoExecuteStatus Enabled
DatabaseName : ContosoRunner
ResourceGroupName : ContosoRunnersProd
ServerName : runner-australia-east
AdvisorName : CreateIndex
AdvisorStatus : GA
AutoExecuteStatus : Enabled
AutoExecuteStatusInheritedFrom : Database
LastChecked : 8/1/2016 2:36:47 PM
RecommendationsStatus : Ok
RecommendedActions : {}
This command changes the auto execute status of an advisor named CreateIndex to Enabled.
RELATED LINKS
Online Version: https://docs.microsoft.com/en-us/powers ... cutestatus
Get-AzureRmSqlDatabaseAdvisor
SQL Database Documentation https://docs.microsoft.com/azure/sql-database/