This option enables you to specify Scheduled Downtime for Scheduled Event and Report Managers under SQL Server. It lets you temporarily suspend operation of the event managers, including Scheduled Events, Report Events, and TechAnywhere Events. These registry settings are needed so that certain SQL server maintenance tasks can be completed in SQL Server. These tasks include Reorganizing and Rebuilding Indices.
We strongly recommend that you consult with your support representative before implementing any of these entries.
Testing Your Registry Entries
The system does not verify the validity of registry entries. Be sure to test your registry entries after completing them to verify that they are functioning correctly.
Setting Values are Uppercase-Lowercase Sensitive:
The Setting Value is case-sensitive: be sure that you enter the value exactly as specified in the documentation. If the documentation specifies a value of true, do NOT enter True or TRUE.
Id:
This option impacts the following registry entries:
sys-start-stchanywhreevntmngr
sys-start-sschdldevntmngr
sys-start-sschdldrprtmngr
Setting Key: Downtime Setting Value: start_end
The downtime is specified in military time (e.g., 12:30 AM = 0030, 11:15 PM = 2315) and should last for at least an hour. The downtime that you specify needs to be in sync with the time the SQL Server is firing the Reorganizing and Rebuilding Indexes. The Scheduled Events manager needs to be started 10 minutes after the Report and TechAnywhere managers so that there are no conflicts.
All of the managers must be suspended individually as shown in following examples.
Examples
For these examples, we will assume that SQL maintenance runs from midnight until about one in the morning. Since we are not sure exactly when maintenance will end, we have given ourselves an extra ½ hour of downtime. Note that the Scheduled Event Manager restarts 10 minutes later.
Techanywhere Event Manager (if applicable):
Id: sys-start-stchanywhreevntmngr Setting Key: Downtime Setting Value: 0000_0130
ReportAnywhere Scheduled Report Manager:
Id: sys-start-sschdldrprtmngr Setting Key: Downtime Setting Value: 0000_0130
Scheduled Event Manager: (notice downtime is 10 minutes longer)
Id: sys-start-sschdldevntmngr Setting Key: Downtime Setting Value: 0000_0140