You can use the following procedures to view the data warehouse job status to determine whether a job is running, stopped, or failed.

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 (http://go.microsoft.com/fwlink/?LinkId=178233) in the System Center Service Manager Administrator’s Guide.

To view the status of a data warehouse job by using the Service Manager console

  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, review the list of jobs to view their status.

To view the status of a data warehouse job by using a Windows PowerShell cmdlet

  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.

      Copy Code
    Add-PSSnapIn SMCmdletSnapIn
    
  3. Type the following command, and then press ENTER.

      Copy Code
    Get-SCDWJob
    
  4. Review the list of jobs to view their status.