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.

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:

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

      Copy Code
    Disable-SCDWJobSchedule –JobName Extract_<data warehouse management group name>
      Copy Code
    Disable-SCDWJobSchedule –JobName Extract_<Service Manager management group name>
      Copy Code
    Disable-SCDWJobSchedule –JobName Transform.Common
      Copy Code
    Disable-SCDWJobSchedule –JobName Load.Common
  4. Type exit, and then press ENTER.