How to Prepare Service Manager 2012 SP1 for Upgrade to R2

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

This topic describes how to prepare your System Center 2012 – Service Manager Service Pack 1 (SP1) environment for an upgrade to System Center 2012 R2 Service Manager. To do this, perform the following procedures:

  1. List the data warehouse jobs that are running.

  2. Disable the schedules for data warehouse jobs.

  3. Confirm that the data warehouse jobs have stopped running.

When the data warehouse jobs have stopped running, start the upgrade of the data warehouse management server. After you update the data warehouse management server, wait 10 minutes, and then start the upgrade of the Service Manager management server.

To list the data warehouse jobs by using Windows PowerShell cmdlets

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

  2. Type the following commands, and then press Enter after each command.

    Set-ExecutionPolicy –force RemoteSigned
    
    cd 'C:\Program Files\Microsoft System Center 2012\Service Manager'
    Import-Module .\Microsoft.EnterpriseManagement.Warehouse.Cmdlets.psd1
    
    Get-SCDWJob
    
  3. A list of the data warehouse jobs appears. Use this list to disable data warehouse job schedules by using Windows PowerShell cmdlets.

To disable data warehouse job schedules by using Windows PowerShell cmdlets

  • Type the following commands, and then press Enter after each command.

    Disable-SCDWJobSchedule –JobName Extract_<data warehouse management group name>
    
    Disable-SCDWJobSchedule –JobName Extract_<Service Manager management group name>
    
    Disable-SCDWJobSchedule –JobName Transform.Common
    
    Disable-SCDWJobSchedule –JobName Load.Common
    
    Disable-SCDWJobSchedule –JobName DWMaintenance
    
    Disable-SCDWJobSchedule –JobName MPSyncJob
    
    Start-SCDWJob –JobName MPSyncJob
    

    The last command to start the MPSyncJob will enable the extraction, transformation, and loading (ETL) jobs to run to completion. After that, because all the schedules have been disabled, the jobs will stop. To close the Windows PowerShell window, type exit.

To confirm that the data warehouse jobs have stopped running

  1. In the Service Manager console, click Data Warehouse.

  2. In the Data Warehouse pane, expand Data Warehouse, and then click Data Warehouse Jobs.

  3. In the Data Warehouse Jobs pane, observe the Status column for each data warehouse job. When the status for each job is listed as Not Started, proceed to the next procedure to stop the Self-Service Portal. If no Self-Service Portal exists in your environment, you can start the upgrade process as described in How to Upgrade to System Center 2012 R2 - Service Manager.

-----
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.
-----