Set-​Azure​Sql​Job​Schedule

Updates a schedule.

Syntax

Set-AzureSqlJobSchedule
   [[-AzureSqlJobConnection] <AzureSqlJobConnection>]
   -DayInterval <Int32>
   [-EndTime <DateTimeOffset>]
   -ScheduleName <String[]>
   [-StartTime <DateTimeOffset>]
   [<CommonParameters>]
Set-AzureSqlJobSchedule
   [[-AzureSqlJobConnection] <AzureSqlJobConnection>]
   [-EndTime <DateTimeOffset>]
   -HourInterval <Int32>
   -ScheduleName <String[]>
   [-StartTime <DateTimeOffset>]
   [<CommonParameters>]
Set-AzureSqlJobSchedule
   [[-AzureSqlJobConnection] <AzureSqlJobConnection>]
   [-EndTime <DateTimeOffset>]
   -MinuteInterval <Int32>
   -ScheduleName <String[]>
   [-StartTime <DateTimeOffset>]
   [<CommonParameters>]
Set-AzureSqlJobSchedule
   [[-AzureSqlJobConnection] <AzureSqlJobConnection>]
   [-EndTime <DateTimeOffset>]
   -MonthInterval <Int32>
   -ScheduleName <String[]>
   [-StartTime <DateTimeOffset>]
   [<CommonParameters>]
Set-AzureSqlJobSchedule
   [[-AzureSqlJobConnection] <AzureSqlJobConnection>]
   [-EndTime <DateTimeOffset>]
   [-OneTime]
   -ScheduleName <String[]>
   [-StartTime <DateTimeOffset>]
   [<CommonParameters>]
Set-AzureSqlJobSchedule
   [[-AzureSqlJobConnection] <AzureSqlJobConnection>]
   [-EndTime <DateTimeOffset>]
   -ScheduleName <String[]>
   [-StartTime <DateTimeOffset>]
   -WeekInterval <Int32>
   [<CommonParameters>]

Description

The Set-AzureSqlJobSchedule cmdlet updates a schedule.

Examples

Example 1: Update a schedule to use a different interval

PS C:\>Set-AzureSqlDatabaseJobSchedule -ScheduleName "MySchedule" -MinuteInterval 10
ScheduleName                            Interval                                StartTime                              EndTime                               
------------                            --------                                ---------                              -------                               
MySchedule                              Minutes: 10                             7/10/2015 3:48:46 PM -07:00            12/31/9999 3:59:59 PM -08:00

This command updates the schedule named MySchedule to use a different interval.

Required Parameters

-DayInterval

Specifies the number of days to allow to elapse between jobs.

Type:Int32
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-HourInterval

Specifies the number of hours that elapse between jobs.

Type:Int32
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-MinuteInterval

Specifies the number of minutes that elapse between jobs.

Type:Int32
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-MonthInterval

Specifies the number of months that elapse between jobs.

Type:Int32
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-OneTime

Indicates that the schedule will only execute once on the specified start time.

Type:SwitchParameter
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-ScheduleName

Specifies an array that contains the name of the schedule.

Type:String[]
Position:Named
Default value:None
Accept pipeline input:True (ByPropertyName)
Accept wildcard characters:False
-WeekInterval

Specifies the number of weeks that elapse between jobs.

Type:Int32
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False

Optional Parameters

-AzureSqlJobConnection

Specifies the connection state object for the job. You can get the connection state object through the New-AzureSqlJobConnection cmdlet. If you do not specify this parameter, the connection state is used from a prior call to the Use-AzureSqlJobConnection cmdlet.

Type:AzureSqlJobConnection
Position:1
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-EndTime

Specifies the ending time for the schedule to be active.

Type:DateTimeOffset
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-StartTime

Specifies the starting time for the schedule to be active.

Type:DateTimeOffset
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False