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.
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
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:
- Year (optional field)
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.
NoteThe ? character is acceptable for the Day-Of-Month and Day-of-Week fields. Please see below
Show me an 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”.
/ 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:
and so on..
- 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
* character means each possible value of this field. For Example:
Every minute, Every hour or Every Day.
1/1 in day field is equivalent to * in the same field which is every day in both case.
? 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.