Launch the Scheduler for a live dashboard

In this section you will learn how to:

  • Launch the Scheduler
  • Configure CRON Expression
Show me how

Before starting, please check the service status.Code192 Data Integration Tool. It is responsible for extracting data from Wonderware Historian Server or RESTful web services and incremental update data for web accessible resources on the time based schedulers.

Service status

The service status can be checked by doing a right click on the Code192 Data Integration Tool Icon in Windows task bar which look like below

Right click on it, select Data Integration Tool Service and click Start if the service is not running like below

Now we will Launch the scheduler. It’s also important to understand the CRON Expression explained below to be able to configure the scheduler.

Launch the scheduler

After setting on the Code192 Data Integration Tool service we can publish the reports that were created using Wonderware Historian Server or Web Data Source in the data server by the following way.

Once you have completed the Dashboard click on your data source to configure the Scheduler, select your Wonderware Historian server connection or your Web Data source connection and click on its option button, click on Schedule.

Then, the schedule window opens, it looks like below

CRON Expressions

The Data Integration Tool Schedule requires a CRON expression. The Dashboard Designer Scheduler helps you to generate this expression.

Cron Expressions are strings that are actually made up of seven sub-expressions, that describe individual details of the schedule. These sub-expressions are separated with white-space, and represent:

  • Seconds
  • Minutes
  • Hours
  • Day-of-Month
  • Month
  • Day-of-Week
  • Year (optional field)

Note

Seconds field is currently not available in the Dashboard Designer scheduler

The Day-of-Month field can be specified as values between 0 and 11 for Jannuary to December or strings like JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV and DEC.

The Day-of-Week field can be specified as values between 1 and 7 (1 for Sunday) or by using the strings SUN, MON, TUE, WED, THU, FRI and SAT.

Note

The ? character is acceptable for the Day-Of-Month and Day-of-Week fields. Please see below
Show me an Example

Example

A CRON expression like: 0 0/0 0/1 1/1 * ? *

We could translate by “Update the dashboard every hours of every Day”.

It would be in our common language “Update every hour”.

The / character

The / character can be used to specify increments to values. For example, 0/15 in the minute’s field means starts every 15 minutes from an hour starting at minute 0.

So, that will start at 15,30,45 minutes of each hour.

Now, if you want to start each hour from 30 minutes start (nothing between 0 and 29 minutes of each hour) and each 10 minutes interval from that, you can set 30/10 in the minutes field.

So, It will start each hour at 30,40,50 minutes of each hour.

So, if it’s 1pm and your CRON expression is : 0 30/10 0/1 1/1 * ? *

Update will start only at:

  • 1:30pm
  • 1:40pm
  • 1:50pm
  • 2:30pm
  • 2:40pm
  • 2:50pm
  • 3:30pm

and so on..

Note

  • The 0/1 in the hours field means each hour from midnight
  • The 1/1 in the Day-of-Month field means every day from the first

The * character

The * character means each possible value of this field. For Example: Every minute, Every hour or Every Day.

Note

1/1 in day field is equivalent to * in the same field which is every day in both case.

The ? character

The ? character is allowed for the day-of-month and day-of-week fields. It is used to specify no specific value. Useful when you don’t want to specify a particular day.