Export (0) Print
Expand All

How to Schedule a Data Warehouse Job

Updated: November 1, 2013

Applies To: System Center 2012 - Service Manager, System Center 2012 R2 Service Manager, System Center 2012 SP1 - Service Manager

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

You could use this procedure in a scenario where a schedule for the data warehouse jobs has been defined in Service Manager. 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:

Set-SCDWJobSchedule -JobName Transform.Common –ScheduleType Daily -DailyFrequency  01:00:00 -DailyStart 06:00

Set-SCDWJobSchedule -JobName Transform.Common -ScheduleType Weekly -WeeklyFrequency Tuesday, Thursday -WeeklyStart 06:00
noteNote
To run Windows PowerShell cmdlets, the execution policy must be set to RemoteSigned. For more information, see Getting Started with the Service Manager Cmdlets in the Deployment Guide for System Center 2012 – Service Manager.

In the following procedure, you configure 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 configure a schedule for data warehouse jobs

  1. On the computer that hosts the data warehouse management server, click Start, point to All Programs, click Microsoft System Center, click Service Manager 2012, and then click Service Manager Shell.

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

    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 All Programs, click Microsoft System Center, click Service Manager 2012, and then click Service Manager Shell.

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

    Get-SCDWJobSchedule
    

See Also

-----
For additional resources, see Information and Support for System Center 2012.

Tip: Use this query to find online documentation in the TechNet Library for System Center 2012. For instructions and examples, see Search the System Center 2012 Documentation Library.
-----
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft