User Manual

SST/OB Advanced User Functions 64
9. Click on the OK button in the Chart Properties box. This displays the New SQL-based View dialog box.
10. Click on the Options tab to configure the execution options for the view. This displays the corresponding
tab page.
Figure 9-15 New SQL-based View Dialog Box – Options Tab Page
• Select the View is dependent on the results of one or more Standard Policies check box if the results to
be displayed in the view are dependent on one or more Standard Policies.
• Specify the execution status as Active or Inactive using the corresponding radio buttons.
• Enter the Execution Frequency Interval in seconds in the corresponding box. Typically, this value would
be about 4 to 5 times the duration it normally takes to execute the query for this view.
• Specify the Start Time and Stop Time between which the view will be executed daily. To execute the
view at all times in a day, specify 00:00 as the Start Time and 23:59 as the Stop Time. Time values are
in 24 hour HH:MM format in the local time in the SSTOB Database Server. When the Stop Time is less
than the Start Time, it indicates that the Stop Time is for the next day. The start time and stop time are
in reference to the SSTOB database server time.
11. Click on the OK button on the New-SQL based View dialog box. This displays the Views dialog box with
the new SQL-based Local View added.