Creating Task Schedules

A Task Schedule is a timed task that occurs on a Check and Posting Service Host or on a workstation. These tasks perform database-related functions that increase performance of the device.

1. Select the Enterprise or property, click Configuration, and then click Task Schedules.
2. Insert a new record or double-click an existing task schedule record to open it in form view.
   The database includes the following default task schedule records:

   • Purge C&P DB data older than 7 days: Cleans the Check and Posting database for records older than seven days.

   • Purge WS DB data older than 7 days: Cleans the workstation database for records older than seven days.

   • Update C&P DB Statistics: Runs an Update Statistics command on the Check and Posting database.

   • Update WS DB Statistics: Runs an Update Statistics command on the workstation database.

   The purge jobs clear check and totals information, along with message requests that are stored in the local database.

3. From the General Settings section, enter information in the fields as described in the following table:

   Table 45-6 General Settings

   Field	Description
   Service Type	Select the type of service to receive the task, either 7 - Workstation or 8 - Check and Posting.
   Service ID	Select the service identification for which the task runs. You can only change this value at the property level.
   Task Type	Select the type of task. When the task schedule is: Database purge, the database for the selected service purges old data. The Task Data field should indicate the number of days to keep data in the local database. Update statistics, the local database performs an update statistics job at the scheduled time. The Task Data field should contain a semicolon-separated list of database tables on which the Update Statistics command runs. Run script, the Task Data field should contain the full path to a script to execute.
   Task Data	This value shows the relevant data for the Task Type.
   Duration (seconds)	Enter the duration of the task. The duration time prevents the task from running too long. The duration time does not cause tasks to terminate immediately. For example, the Update Statistics job finishes each database table listed, and then checks the duration of the overall task.
   Time Zone	Select the time zone for the task, which determines the time of day when the task runs. A common setting for this field is 0 - Local Time Zone, causing the task to run in each property based on the local time at the property.
   Schedule Type	Select the recurrence frequency for the task schedule (for example, one time, daily, weekly, or monthly).

4. From the Duration section, select Enabled to run the task schedule at the set time. Deselect this option if you do not want the task schedule to run.
   1. In the Start date field, select the first date for the task schedule to run.
   2. To end the task schedule on a specific date, select End date, and then select the date for the task schedule to end. If the task schedule has no end date, select No end date.
5. If you selected a recurring frequency in the Schedule Type field, click the Recurrence tab. The available fields are based on the recurring frequency you selected (daily, weekly, or monthly).
6. Select the appropriate day and time options for the frequency.
7. Click Save.