Set-AzSqlElasticJob
Uppdateringar ett jobb
Syntax
Set-AzSqlElasticJob
[-ResourceGroupName] <String>
[-ServerName] <String>
[-AgentName] <String>
[-Name] <String>
[-StartTime <DateTime>]
[-EndTime <DateTime>]
[-Enable]
[-Description <String>]
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>]
Set-AzSqlElasticJob
[-ResourceGroupName] <String>
[-ServerName] <String>
[-AgentName] <String>
[-Name] <String>
[-RunOnce]
[-StartTime <DateTime>]
[-EndTime <DateTime>]
[-Enable]
[-Description <String>]
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>]
Set-AzSqlElasticJob
[-ResourceGroupName] <String>
[-ServerName] <String>
[-AgentName] <String>
[-Name] <String>
-IntervalType <String>
-IntervalCount <UInt32>
[-StartTime <DateTime>]
[-EndTime <DateTime>]
[-Enable]
[-Description <String>]
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>]
Set-AzSqlElasticJob
[-InputObject] <AzureSqlElasticJobModel>
[-StartTime <DateTime>]
[-EndTime <DateTime>]
[-Enable]
[-Description <String>]
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>]
Set-AzSqlElasticJob
[-InputObject] <AzureSqlElasticJobModel>
[-RunOnce]
[-StartTime <DateTime>]
[-EndTime <DateTime>]
[-Enable]
[-Description <String>]
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>]
Set-AzSqlElasticJob
[-InputObject] <AzureSqlElasticJobModel>
-IntervalType <String>
-IntervalCount <UInt32>
[-StartTime <DateTime>]
[-EndTime <DateTime>]
[-Enable]
[-Description <String>]
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>]
Set-AzSqlElasticJob
[-ResourceId] <String>
[-StartTime <DateTime>]
[-EndTime <DateTime>]
[-Enable]
[-Description <String>]
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>]
Set-AzSqlElasticJob
[-ResourceId] <String>
[-RunOnce]
[-StartTime <DateTime>]
[-EndTime <DateTime>]
[-Enable]
[-Description <String>]
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>]
Set-AzSqlElasticJob
[-ResourceId] <String>
-IntervalType <String>
-IntervalCount <UInt32>
[-StartTime <DateTime>]
[-EndTime <DateTime>]
[-Enable]
[-Description <String>]
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>]
Description
Cmdleten Set-AzSqlElasticJob uppdaterar ett jobb
Exempel
Exempel 1: Uppdateringar ett jobb för att starta en timme från och med nu och upprepa var 1 timme
$job = Get-AzSqlElasticJob -ResourceGroupName rg -ServerName elasticjobserver -AgentName agent -Name job1
$job | Set-AzSqlElasticJob -IntervalType Hour -IntervalCount 1 -StartTime (Get-Date).AddHours(1) -Enable
JobName Version Description StartTime EndTime ScheduleType Interval Enabled
------- ------- ----------- --------- ------- ------------ -------- -------
job1 0 6/1/2018 10:50:15 PM 12/31/9999 11:59:59 AM Recurring PT1H True
Uppdateringar ett jobb
Exempel 2
Set-AzSqlElasticJob -AgentName agent -Enable -IntervalCount 1 -IntervalType Hour -Name step1 -ResourceGroupName MyResourceGroup -ServerName s1 -StartTime '9/16/2016 11:31:12'
Parametrar
-AgentName
Agentnamnet
Type: | String |
Position: | 2 |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-Confirm
Uppmanar dig att bekräfta innan du kör cmdleten.
Type: | SwitchParameter |
Aliases: | cf |
Position: | Named |
Default value: | False |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-DefaultProfile
Autentiseringsuppgifter, konto, klientorganisation och prenumeration som används för kommunikation med Azure.
Type: | IAzureContextContainer |
Aliases: | AzContext, AzureRmContext, AzureCredential |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-Description
Jobbbeskrivningen
Type: | String |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-Enable
Flaggan som anger att kunden vill att det här jobbet ska aktiveras.
Type: | SwitchParameter |
Position: | Named |
Default value: | False |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-EndTime
Jobbschemats sluttid
Type: | Nullable<T>[DateTime] |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-InputObject
Jobbets indataobjekt
Type: | AzureSqlElasticJobModel |
Position: | 0 |
Default value: | None |
Required: | True |
Accept pipeline input: | True |
Accept wildcard characters: | False |
-IntervalCount
Antal återkommande schemaintervall
Type: | Nullable<T>[UInt32] |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-IntervalType
Den återkommande schemaintervalltypen – kan vara minut, timme, dag, vecka, månad
Type: | String |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-Name
Jobbnamnet
Type: | String |
Aliases: | JobName |
Position: | 3 |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-ResourceGroupName
Resursgruppens namn
Type: | String |
Position: | 0 |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-ResourceId
Jobbresurs-ID:t
Type: | String |
Position: | 0 |
Default value: | None |
Required: | True |
Accept pipeline input: | True |
Accept wildcard characters: | False |
-RunOnce
Flaggan som anger att jobbet ska köras en gång
Type: | SwitchParameter |
Position: | Named |
Default value: | False |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-ServerName
Servernamnet
Type: | String |
Position: | 1 |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-StartTime
Starttid för jobbschemat
Type: | Nullable<T>[DateTime] |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-WhatIf
Visar vad som skulle hända om cmdleten kördes. Cmdleten körs inte.
Type: | SwitchParameter |
Aliases: | wi |
Position: | Named |
Default value: | False |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |