How to Prepare Service Manager 2010 for Upgrade to SP1

  • Article

Applies To: System Center Service Manager 2010 SP1

This topic describes how to prepare your Service Manager environment for an upgrade to System Center Service Manager 2010 SP1. Perform the following procedures for upgrading the data warehouse management server:

  1. List the data warehouse jobs that are running.

  2. Disable the data warehouse job schedules.

  3. Make sure that the data warehouse jobs have stopped running.

  4. When the data warehouse jobs have completed, start the upgrade of the data warehouse management server.

After the data warehouse has been upgraded, perform the following procedures on the first Service Manager management server:

  1. Stop the Self-Service Portal.

  2. 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, point to Programs, point to Windows PowerShell 1.0, right-click Windows PowerShell, and then click Run as administrator.

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

    Set-ExecutionPolicy RemoteSigned

Add-PSSnapin SMCmdletSnapIn

Get-SCDWJob

  3. A list of the data warehouse jobs is displayed. Use this list in the next procedure, "To disable data warehouse job schedules by using Windows PowerShell cmdlets".

To disable data warehouse job schedules by using Windows PowerShell cmdlets

  1. 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 ETL jobs to run to completion and after that, because all the schedules have been disabled, the jobs will stop.

To determine 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, start the upgrade of the data warehouse management server.

To stop the Self-Service Portal

  1. On the computer that hosts the Self-Service Portal, on the Windows desktop, click Start, point to Programs, point to Administrative Tools, and then click Internet Information Services (IIS) Manager.

  2. In the Internet Information Services (IIS) Manager window, in the Connections pane, right-click the name of your computer, and then click Stop.

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