How to Enable Data Warehouse Job Schedules
Updated: December 1, 2010
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.
To run the commands in this topic, the execution policy in Windows PowerShell must be set to RemoteSigned. Type the command
To enable a schedule for a data warehouse job by using a Windows PowerShell cmdlet
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.
At the Windows PowerShell command prompt, type the following command, and then press ENTER:
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
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 firstname.lastname@example.org.