TechNet
Table of contents
TOC
Collapse the table of content
Expand the table of content

How to Disable a Data Warehouse Job Schedule

Bill Anderson|Last Updated: 8/15/2016

Applies To: System Center 2016 Technical Preview - Service Manager

You can use the following procedure to disable the schedule for the extract, transform, and load (ETL) jobs; however, you can use this procedure 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 cmdlets.

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 All Programs, click Microsoft System Center, click Service Manager 2016, and then click Service Manager Shell.

  2. At the Windows PowerShell prompt, type the following commands, and 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
    
  3. Type exit, and then press ENTER.

© 2016 Microsoft