Introduction

The purpose of this task is to create indexes on the Log and Log_Field tables in the Microsoft SQL database.

The task can be found by navigating to the task, then scrolling down to the task "Create Log indexes for Microsoft SQL";

Task Parameters

This task does not use any task parameters.

Editing and Scheduling the Task

Viewing and Editing Tasks

The task can be edited by left clicking on the context menu of the task and selecting "Edit";

A new window will now open titled "Task - Edit";




Enter the name to be assigned to the task within the management console.


Enter a description of what the task will do.


The version number of the task.


This field is used to specify when the task is scheduled to execute.


This field will determine if the task schedule is enabled (if enabled the task will execute at the scheduled time).


Specifies how many times the task should be repeated after the task is executed.



import com.deepnet.das.util.Util
import com.deepnet.das.system.health.LogTableIndexChecker

def metaInfo =  Util.getDatabaseInfo()

    if(metaInfo.DatabaseProductName!="Microsoft SQL Server"){
setEndMessage("skip non-Microsoft SQL Database")
return
    }

    def result = new LogTableIndexChecker().createIndexes()

setEndMessage("Indexes created: $result")


Scheduling the Task

Select the "Enable Schedule" checkbox to ensure the task schedule is activated, then use the pencil icon ("")  to specify the time and frequency settings for automated task execution.

  • Tasks can be scheduled for automatic execution by selecting the "Schedule Enable" option then clicking on the icon;

    When the is pressed a window will open titled "Schedule" that can be used to specify the when the report is scheduled to run; 


    As an example, we can schedule the report to run at 1am every weekday using the following settings;

    After clicking on the schedule details will be converted into text form and added against the report parameter "Schedule"; 


    In addition to scheduling when the task is to be run you may need to Edit the task parameters and ensure that all required parameters have been supplied (some tasks have parameters with no default value and until a value is supplied the task will fail if run manually or automatically scheduled).

Manual Task Execution

The task can be run manually from the management console by left click on the context menu of the task, then selecting "Run";

A new window will open titled "Execute Task" will then open (the window will be populated with the default task property values);



Provide a brief description that will be used to describe the purpose of the task in the audit log.


To execute the task click  the  button

  • No labels