Set-SCDWJobSchedule

Sets the schedule for a data warehouse job.

Syntax

Set-SCDWJobSchedule
   [-JobName] <String>
   [-DailyFrequency <TimeSpan>]
   [-DailyStart <DateTime>]
   [-WeeklyStart <DateTime>]
   [-ScheduleType <ScheduleTypeEnum>]
   [-WeeklyFrequency <System.Collections.Generic.List`1[System.String]>]
   [-ComputerName <String>]
   [-WhatIf]
   [-Confirm]
   [<CommonParameters>]

Description

The Set-SCDWJobSchedule cmdlet configures the schedule for data warehouse jobs. You can configure the schedule on a daily basis or on a weekly basis.

For a daily schedule, you must specify the time interval at which the job recurs (DailyFrequency) and the time of day at which this recurrence starts (DailyStart).

For a weekly schedule, you must specify the time of day (WeeklyStart) at which the job should run and the list of days for which this start time is effective (WeeklyFrequency).

Examples

Example 1: Schedule a job to run every 30 minutes

PS C:\>Set-SCDWJobSchedule -ComputerName "serverDW72" -JobName "Transform.Common" -DailyFrequency 00:30 -DailyStart 00:00

This command sets the schedule for the Transform.Common job, to run every 30 minutes starting at midnight.

Parameters

-ComputerName

Specifies the name of the computer on which the System Center Data Access service is running. You can omit this parameter only if the System Center Data Access Service is running on the same computer that has Service Manager installed.

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

-Confirm

Prompts you for confirmation before running the cmdlet.

Type:SwitchParameter
Aliases:cf
Position:Named
Default value:False
Required:False
Accept pipeline input:False
Accept wildcard characters:False

-DailyFrequency

Specifies the recurrence frequency of the scheduled job for a daily schedule.

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

-DailyStart

Specifies the time at which the scheduled job will start for a daily schedule. Specify the start time in the hh:mm format.

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

-JobName

Specifies the Data Warehouse job for which the schedule is being configured.

Type:String
Position:1
Default value:None
Required:True
Accept pipeline input:False
Accept wildcard characters:False

-ScheduleType

Specifies the schedule as Daily or Weekly. The default value is Daily.

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

-WeeklyFrequency

Specifies the days on which the job will run for a weekly schedule. The job will start according to the time that is specified by the WeeklyStart parameter. Use a comma to separate multiple days (for example: Tuesday, Thursday).

Type:System.Collections.Generic.List`1[System.String]
Position:Named
Default value:None
Required:False
Accept pipeline input:False
Accept wildcard characters:False

-WeeklyStart

Specifies the time of day at which the job will start for a weekly schedule (for example: 8:00, 16:00). The job will begin at this time on the days that are specified by the WeeklyFrequency parameter. Specify the start time in the hh:mm format.

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

-WhatIf

Shows what would happen if the cmdlet runs. The cmdlet is not run.

Type:SwitchParameter
Aliases:wi
Position:Named
Default value:False
Required:False
Accept pipeline input:False
Accept wildcard characters:False

Inputs

None.

You cannot pipe input to this cmdlet.

Outputs

None.

This cmdlet does not generate any output.

Notes

  • Valid schedule parameter combinations are as follows:

    -DailyFrequencyHH:MMâ€"DailyStartHH:MM-ScheduleType Daily

    -WeeklyFrequencyDay(s)â€"WeeklyStartHH:MM, -ScheduleType Weekly

    For the weekly frequency, specify the day of the week such as Monday. For multiple days, separate with commas such as Monday, Tuesday, Wednesday. You cannot configure a job with both a weekly schedule and a daily schedule.