Set-AzureSqlJobSchedule
Updates a schedule.
Syntax
Set-AzureSqlJobSchedule
-ScheduleName <String[]>
[-StartTime <DateTimeOffset>]
[-EndTime <DateTimeOffset>]
[[-AzureSqlJobConnection] <AzureSqlJobConnection>]
[<CommonParameters>]
Set-AzureSqlJobSchedule
-ScheduleName <String[]>
[-StartTime <DateTimeOffset>]
[-EndTime <DateTimeOffset>]
[-OneTime]
[[-AzureSqlJobConnection] <AzureSqlJobConnection>]
[<CommonParameters>]
Set-AzureSqlJobSchedule
-ScheduleName <String[]>
[-StartTime <DateTimeOffset>]
[-EndTime <DateTimeOffset>]
-MinuteInterval <Int32>
[[-AzureSqlJobConnection] <AzureSqlJobConnection>]
[<CommonParameters>]
Set-AzureSqlJobSchedule
-ScheduleName <String[]>
[-StartTime <DateTimeOffset>]
[-EndTime <DateTimeOffset>]
-HourInterval <Int32>
[[-AzureSqlJobConnection] <AzureSqlJobConnection>]
[<CommonParameters>]
Set-AzureSqlJobSchedule
-ScheduleName <String[]>
[-StartTime <DateTimeOffset>]
[-EndTime <DateTimeOffset>]
-DayInterval <Int32>
[[-AzureSqlJobConnection] <AzureSqlJobConnection>]
[<CommonParameters>]
Set-AzureSqlJobSchedule
-ScheduleName <String[]>
[-StartTime <DateTimeOffset>]
[-EndTime <DateTimeOffset>]
-WeekInterval <Int32>
[[-AzureSqlJobConnection] <AzureSqlJobConnection>]
[<CommonParameters>]
Set-AzureSqlJobSchedule
-ScheduleName <String[]>
[-StartTime <DateTimeOffset>]
[-EndTime <DateTimeOffset>]
-MonthInterval <Int32>
[[-AzureSqlJobConnection] <AzureSqlJobConnection>]
[<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.
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 |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-DayInterval
Specifies the number of days to allow to elapse between jobs.
Type: | Int32 |
Position: | Named |
Default value: | None |
Required: | True |
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 |
Required: | False |
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 |
Required: | True |
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 |
Required: | True |
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 |
Required: | True |
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 |
Required: | True |
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 |
Required: | True |
Accept pipeline input: | True |
Accept wildcard characters: | False |
-StartTime
Specifies the starting time for the schedule to be active.
Type: | DateTimeOffset |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-WeekInterval
Specifies the number of weeks that elapse between jobs.
Type: | Int32 |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
Related Links
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for