Platform Deployment Guide › Data Warehouse › Advanced Configuration › Reconfigure a Data Warehousing Job › Reschedule the Initial Off-Peak Jobs

Reschedule the Initial Off-Peak Jobs

On CMSs with over 100,000 events, CA DataMinder prioritizes events captured in the last 3 days. It then gradually processes the remaining older events by running off-peak data warehousing job each night. By default, the window for these jobs starts at midnight and lasts for 300 minutes but you can reschedule data warehousing jobs to run when you want.

Why Reschedule Off-peak Data Warehousing Jobs?

The default scheduling means that any reports which query the data warehouse, or any charts or tables in the iConsole dashboard, may contain incomplete data until all relevant event data has been added to the data warehouse. But you can circumvent this problem by rescheduling the off-peak data warehousing jobs. Alternatively, you can disable the off-peak jobs and run them later at a more convenient time.

If you reschedule data warehousing jobs, be aware of the following:

• The data processing associated with these data warehousing jobs can generate a heavy workload on the CMS. We strongly recommend that you run these jobs during offpeak times.
• If you change the job frequency, you must be logged onto the CMS database as the primary user. This is the account that CA DataMinder uses to access the CMS database.

To Reschedule Off-peak Data Warehousing Jobs

Run the following commands to specify an alternative start time and duration.

SQL Server Host Servers

Run this command:

EXEC WgnDW_Configure_DW 
  @Offpeak_Run_Starttime_Hour=<hour>, 
  @Offpeak_Run_Timeout_Mins=<window>  

<hour> specifies the starting hour. It can be any value from 0 to 23. For example, 0 specifies a midnight start and 23 specifies an 11 pm start.

<window> specifies the window duration (in minutes) for the job. For example, set this to 240 to specify a four hour window.

Oracle Host Servers

Run this command:

BEGIN
  WgnDW_Configure_DW( 
    Offpeak_Run_Starttime_Hour=><hour>, 
    Offpeak_Run_Timeout_Mins=><window> );
END;

Where <hour> and <window> are as described above.

To Disable Off-peak Data Warehousing Jobs

Run the above commands, but set <window> to -1 to disable off-peak jobs. For example, you may want to disable these jobs Monday through Friday but re-enable them over the weekend.

SQL Server Host Servers

Run this command:

EXEC WgnDW_Configure_DW 
  @Offpeak_Run_Starttime_Hour=0, 
  @Offpeak_Run_Timeout_Mins=-1  

Oracle Host Servers

Run this command:

BEGIN
  WgnDW_Configure_DW( 
    Offpeak_Run_Starttime_Hour=>0, 
    Offpeak_Run_Timeout_Mins=>-1 );
END;