Set-SCDWJobSchedule

Set-SCDWJobSchedule

Sets the schedule for a data warehouse job.

Syntax

Parameter Set: Default
Set-SCDWJobSchedule [-JobName] <String> [-ComputerName <String> ] [-DailyFrequency <Nullable`1> ] [-DailyStart <Nullable`1> ] [-ScheduleType <ScheduleTypeEnum> ] [-WeeklyFrequency <List`1> ] [-WeeklyStart <Nullable`1> ] [-Confirm] [-WhatIf] [ <CommonParameters>]

Detailed 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).

Parameters

-ComputerName<String>

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.

Aliases

none

Required?

false

Position?

named

Default Value

none

Accept Pipeline Input?

false

Accept Wildcard Characters?

false

-DailyFrequency<Nullable`1>

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

Aliases

none

Required?

false

Position?

named

Default Value

none

Accept Pipeline Input?

false

Accept Wildcard Characters?

false

-DailyStart<Nullable`1>

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

Aliases

none

Required?

false

Position?

named

Default Value

none

Accept Pipeline Input?

false

Accept Wildcard Characters?

false

-JobName<String>

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

Aliases

none

Required?

true

Position?

1

Default Value

none

Accept Pipeline Input?

false

Accept Wildcard Characters?

false

-ScheduleType<ScheduleTypeEnum>

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

Aliases

none

Required?

false

Position?

named

Default Value

none

Accept Pipeline Input?

false

Accept Wildcard Characters?

false

-WeeklyFrequency<List`1>

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).

Aliases

none

Required?

false

Position?

named

Default Value

none

Accept Pipeline Input?

false

Accept Wildcard Characters?

false

-WeeklyStart<Nullable`1>

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.

Aliases

none

Required?

false

Position?

named

Default Value

none

Accept Pipeline Input?

false

Accept Wildcard Characters?

false

-Confirm

Prompts you for confirmation before running the cmdlet.

Required?

false

Position?

named

Default Value

false

Accept Pipeline Input?

false

Accept Wildcard Characters?

false

-WhatIf

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, -OutBuffer, and -OutVariable. For more information, see    about_CommonParameters (https://go.microsoft.com/fwlink/p/?LinkID=113216).

Inputs

The input type is the type of the objects that you can pipe to the cmdlet.

  • None.

    You cannot pipe input to this cmdlet.

Outputs

The output type is the type of the objects that the cmdlet emits.

  • 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.

Examples

Example 1: Schedule a job to run every 30 minutes

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

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

Disable-SCDWJobSchedule

Enable-SCDWJobSchedule

Get-SCDWJobSchedule