Previous Topic: Is_EP_Fact_EnabledNext Topic: Offpeak_Run_Timeout_Mins


Offpeak_Run_Starttime_Hour

Use this parameter to specify the starting hour for an off-peak processing job.

Off-peak processing jobs perform various Data Warehouse maintenance routines, including purges. The default window for these jobs is midnight until 5am.

The first job that runs within this window performs various database maintenance routines. Some routines can take a very long time (such as historic backlog processing). If the routines do not finish before the window expires, they suspend themselves until the next off-peak processing window.

Syntax

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

SQL Server
@Offpeak_Run_Starttime_Hour=<hour>
Oracle
Offpeak_Run_Starttime_Hour=><hour>
Examples

These examples specify a 1am start for the off-peak processing job:

@Offpeak_Run_Starttime_Hour=1
Offpeak_Run_Starttime_Hour=>1