New Task Setup

Add new tasks for the Scheduler by using the New Task Setup wizard.

You can create tasks or sensors and schedule them to run at specific times.

• Tasks run a specific job at a specific time or interval.
• Sensors collect and save information.

Fields and buttons:

Startup Only

Select this check box if you want the task or sensor to run only when the database server starts.

Task Name

Enter an alphanumeric string that identifies the task. The string can include alphabetic, numeric, and special characters, but not a blank or space.

Sensor Name

Enter an alphanumeric string that identifies the sensor. The string can include alphabetic, numeric, and special characters, but not a blank or space.

Task Group or Sensor Group

Select a group for the task or sensor. These groups are used to organize the tasks for viewing on the Task Scheduler > Task Details page. The group has no affect on the data.

Start Time

Select the beginning time of the allowable time frame in which the task can run. Specify the value by using the 24-hour clock fields. For example, if you want the task to run at or after 2:00 p.m., select 14:00:00. To run the task continuously, set the start time to 00:00:00 and set the stop time to 23:59:00.

Stop Time

Select the end time of the allowable time frame in which the task can run. Specify the value using the 24-hour clock fields. For example, if you want the task to stop running before 7:00 p.m., select 19:00:00. The task runs for the last time until 18:59:59, and then waits until the next allowable time frame to start again. To run the task continuously, set the start time to 00:00:00 and set the stop time to 23:59:00.

Frequency

Specify how often within the allowable time frame the task is run, in days, hours, and minutes. For example, if the allowable time frame is between 14:00:00 and 19:00:00, and you enter 0 Days 0 Hours 15 Minutes, the task runs at 14:00:00. The task repeats every 15 minutes until the last run before 19:00:00, but will not run after 19:00:00. The next run time begins at 14:00:00 for the following day.

Important: The time at which you create the task affects the first execution of the task. If the current time is 15:00:00, using the example above, the task begins to execute 15 minutes after you schedule it, at 15:15:00. It repeats in 15 minutes, and continues through the last execution that begins before 19:00:00. The task stops executing at the stop time and waits until the next day at 14:00:00 to begin the next run.

Data Delete

Specify the length of time, in days, hours, and minutes, until sensor data is deleted from the results table.

Result Table Name

Enter a string that begins with an underscore or alphabetic character. The string can contain alphabetic and numeric characters, and underscores. The string cannot begin with a number or special character other than an underscore (_). For example: myTable

Statement

Enter the command to be run by the task. It can contain a user-defined function, a single SQL statement, or a multiple-statement prepared object. A multi-statement prepared object is a PREPARE SQL statement that enables the assembly of one or more SQL statements at run time.

SQL Statement

Complete the CREATE TABLE SQL statement by entering the names and data types of each column. For example: create table result_table_name (name varchar(20), id integer). By default, the result table is created in the SYSADMIN database, unless you specify another database in which to create the result table.

By default, the task is enabled to run every day of the week. To change the days on which the task is run, on the Task Scheduler > Task Details page, click the task name. Then disable the task for any days on which you do not want the task to run.