You can use the following procedure to schedule a data warehouse job in System Center Service Manager 2012.

You could use this procedure in a scenario where a schedule for the data warehouse jobs has been defined in Service Manager 2012. You want to change the schedule for the data warehouse jobs to define standard maintenance windows for the Service Manager database and for the data warehouse. Use the Set-SCDWJobSchedule cmdlet to schedule the data warehouse jobs. The Set-SCDWJobSchedule –ScheduleType Weekly cmdlet and parameter combination allows jobs to run only on the days you specify. For example, the following commands define a daily or weekly schedule.

  Copy Code 
Set-SCDWJobSchedule -JobName Transform.Common –ScheduleType Daily -DailyFrequency  01:00:00 -DailyStart 06:00
  Copy Code 
Set-SCDWJobSchedule -JobName Transform.Common -ScheduleType Weekly -WeeklyFrequency Tuesday, Thursday -WeeklyStart 06:00
Note
To run Windows PowerShell cmdlets, the execution policy must be set to RemoteSigned. For more information, see Getting Started with the Service Manager Cmdlets (http://go.microsoft.com/fwlink/?LinkId=129134) in the System Center Service Manager Deployment Guide.

In the following procedure, you set a schedule for the Transform job to run every 45 minutes starting at 2:00 in the morning. However, you can modify the commands to set your own schedule.

To schedule data warehouse jobs

  1. On the computer that hosts the data warehouse management server, click Start, point to Programs, point to Windows PowerShell 1.0, right-click Windows PowerShell, and then click Run as administrator.

  2. At the Windows PowerShell prompt, type the following command, and then press ENTER.

      Copy Code 
    Add-PSSnapIn SMCmdletSnapIn

  3. At the Windows PowerShell prompt, type the following command, and then press ENTER.

      Copy Code 
    Set-SCDWJobSchedule -JobName Transform.Common -ScheduleType Daily –DailyFrequency 00:45:00 –DailyStart 02:00

To validate a data warehouse job schedule

  1. On the computer that hosts the data warehouse management server, click Start, point to Programs, point to Windows PowerShell 1.0, right-click Windows PowerShell, and then click Run as administrator.

  2. At the Windows PowerShell prompt, type the following command, and then press ENTER.

      Copy Code 
    Add-PSSnapIn SMCmdletSnapIn

  3. Type the following command, and then press ENTER:

      Copy Code 
    Get-SCDWJobSchedule