How to Enable Data Warehouse Job Schedules

  • Article

Applies To: System Center Service Manager 2010 SP1

By default, the schedules for the extract, transform, and load (ETL) jobs are not enabled. Use the following procedure to enable the schedule for the ETL jobs; however, this procedure can be used to enable the schedule for any of the data warehouse jobs. In this release of Service Manager, you can enable the schedules only by using Windows PowerShell. Additionally, in this release, it is not possible to query for the status of a data warehouse job schedule. If you have to know the status of a particular job, run the command to enable it.

Note

To run the commands in this topic, the execution policy in Windows PowerShell must be set to RemoteSigned. Type the command Set-ExecutionPolicy RemoteSigned to set the execution policy.

To enable a schedule for a data warehouse job by using a Windows PowerShell cmdlet

  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 command prompt, type the following command, and then press ENTER:

    Add-PSSnapIn SMCmdletSnapIn

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

    Enable-SCDWJobSchedule –JobName Extract_<data warehouse management group name>

Enable-SCDWJobSchedule –JobName Extract_<Service Manager management group name>

Enable-SCDWJobSchedule –JobName Transform.Common

Enable-SCDWJobSchedule –JobName Load.Common

  4. Type exit, and then press ENTER.

Did you find this information helpful? Please send your suggestions and comments about System Center Service Manager documentation to scsmdocs@microsoft.com.