Monday, April 30, 2012

Enable Schedule for SCSM 2012 ETL

By default, the schedules for the extract, transform, and load (ETL) jobs are not enabled. If ETL is now enabled, you will get no data from SCSM console when generating any report.

In this release of Service Manager (System Center 2012 – Service Manager), you can enable the schedules only by using Windows PowerShell.


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