How to Disable a Data Warehouse Job Schedule

Applies To: System Center Service Manager 2010 SP1

Use the following procedure to disable the schedule for the ETL jobs; however, this procedure can be used to disable the schedule for any data warehouse job. In this release of Service Manager, you can disable the schedules only by using Windows PowerShell. Additionally, in this release, it is not possible to query for the status of a data warehouse job schedule.

Note

To run the commands in this topic, the execution policy in Windows PowerShell must be set to RemoteSigned. For more information about how to set the execution policy, see Getting Started with Service Manager Cmdlets for Windows PowerShell.

To disable a schedule for a data warehouse job 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. 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:

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