How to Suspend and Resume a Data Warehouse Job

  • Article

Applies To: System Center Service Manager 2010 SP1

You can suspend (or pause) and resume data warehouse jobs that are running. For example, you might have to suspend all of the data warehouse jobs that are running to ensure that a security update to the data warehouse management server does not interfere with any jobs that might run. After the server has been updated and restarted, you resume all the data warehouse jobs. You can suspend (or pause) and then resume jobs by using the Service Manager console or by using Windows PowerShell cmdlets. In this example, only the extract, transform, and load (ETL) jobs are running.

Note

To run the Windows PowerShell cmdlets, the execution policy in Windows PowerShell must be set to RemoteSigned. For more information, see Getting Started with the Service Manager Cmdlets (https://go.microsoft.com/fwlink/?LinkId=178233) in the System Center Service Manager 2010 Administrator’s Guide.

To pause and resume data warehouse jobs using the Service Manager console

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

  2. Expand Data Warehouse, and then click Data Warehouse Jobs.

  3. In the Data Warehouse Jobs pane, select a job that is running, and then click Suspend in the Tasks list.

  4. Repeat the previous step for each data warehouse job.

  5. To resume each job, select a job that is suspended in the Data Warehouse Jobs pane, and then click Resume in the Tasks list.

To suspend all data warehouse jobs 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. At the Windows PowerShell prompt, type the following command, and then press ENTER.

    Add-PSSnapIn SMCmdletSnapIn

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

    Suspend-SCDWJob –JobName Extract_<data warehouse management group name>

Suspend-SCDWJob –JobName Extract_<Service Manager management group name>

Suspend-SCDWJob –JobName Transform.Common

Suspend-SCDWJob –JobName Load.Common

  4. Type exit, and then press ENTER.

To resume all data warehouse jobs 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. At the Windows PowerShell prompt, type the following command, and then press ENTER.

    Add-PSSnapIn SMCmdletSnapIn

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

    Resume-SCDWJob –JobName Extract_<data warehouse management group name>

Resume-SCDWJob –JobName Extract_<Service Manager management group name>

Resume-SCDWJob –JobName Transform.Common

Resume-SCDWJob –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.