PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Properties specific to the description of hScheduling variables
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
The hScheduling type is used to define and find out the characteristics of the scheduling that must be performed:
  • for a scheduled optimization task of HFSQL Client/Server files.
  • for a scheduled backup task of HFSQL Client/Server files.
  • Versions 18 and later
    for a scheduled replication of HFSQL servers.
    New in version 18
    for a scheduled replication of HFSQL servers.
    for a scheduled replication of HFSQL servers.
The characteristics of this scheduling can be defined and modified by several WLanguage properties.
This type of variable is used:
Note: See Declaring a variable for more details.
Versions 17 and later
iPhone/iPad This type of variable is now available for the iPhone and iPad applications.
New in version 17
iPhone/iPad This type of variable is now available for the iPhone and iPad applications.
iPhone/iPad This type of variable is now available for the iPhone and iPad applications.
Example
// Recalculate the statistics for the files found in "MyDatabase",
// every Saturday at 23:00
Optim is hScheduledOptimization
Optim..Description = "Recalculating the statistics for the files" + ...  
"found in the MyDatabase database"

// Define the scheduling
MyScheduling is hScheduling
MyScheduling..Month = "*"
MyScheduling..DayOfWeek = "Saturday"
MyScheduling..Hour = "23"
MyScheduling..Minute = "0"

Optim..Scheduling = MyScheduling

// Define the files to process
Optim..File[1]..Name = "MyDatabase"
Optim..File[1]..Option = hOptStat

// Add the scheduled optimization
HAddScheduledOptimization(MyConnection, Optim)
Remarks

Properties specific to the description of hScheduling variables

The following properties can be used to handle a scheduling:
Property nameType usedEffect
HourCharacter stringExecution time of the scheduled task in UTC format (universal time). Execution time of scheduled task. If ..TimeUTC is set to True, this time is in UTC format (universal time).
The possible values are:
  • a digit included between 0 and 23.
  • a list of numbers separated by commas: used to specify several hours.
  • an interval. For example, "9-13".
  • a star ("*") to specify the entire range.
  • an interval with a step, "*/2" for example to perform the task at every even hour.
Versions 19 and later
TimeUTC
New in version 19
TimeUTC
TimeUTC
Boolean
  • True (default value) if the time is expressed in UTC time, which means in universal time (..Hour and ..Minute),
  • False otherwise.
DayOfWeekCharacter stringNumber of the day for which the scheduled task must be run ("2" for example). This number is included between 1 and 7 (1 = Monday, 2 = Tuesday, ...).
This property can also correspond to:
  • a list of numbers separated by commas: used to specify several days.
  • an interval. For example, "1-3" (the task is scheduled for Monday, Tuesday and Wednesday).
  • a star ("*") to specify the entire range.
  • an interval with a step, "*/2" for example to perform the task on every even day of the week.
  • the day of the week in letters ("monday", "tuesday", "wednesday", "thursday", "friday").
DayOfMonthCharacter stringNumber of the day for which the scheduled task must be run ("31" for example). This number is included between 0 and 31.
This property can also correspond to:
  • a list of numbers separated by commas: used to specify several months.
  • an interval. For example, "9-13" (the task is scheduled from the 9th to the 13th of the month).
  • a star ("*") to specify the entire range.
  • an interval with a step, "*/2" for example to perform the task on every odd day of the month.
DayOfMonthOrDayOfWeekBooleanUsed to manage the execution of a scheduled task on the HFSQL Client/Server server by specifying the number of the day of the week or the number of the day of the month. Example: execution every Monday 1st day of month.
This property can correspond to:
  • True to run the scheduled task every Monday AND the first day of the month (cumulated conditions).
  • False to run the task on Monday 1st (exclusive conditions).
MinuteCharacter stringMinutes of the execution time of the scheduled task in UTC format (universal time). Minutes of the execution time of the scheduled task. If ..TimeUTC is set to True, this time is in UTC format (universal time).
The possible values are:
  • a digit included between 0 and 59.
  • a list of numbers separated by commas: used to specify several minutes.
  • an interval. For example, "9-13".
  • a star ("*") to specify the entire range.
  • an interval with a step, "*/2" for example to perform the task at every even minute.
MonthCharacter stringNumber of the execution month of scheduled task. The possible values are:
  • a digit included between 1 and 12
  • a list of numbers separated by commas: used to specify several months.
  • an interval. For example, "9-11".
  • a star ("*") to specify the entire range.
  • an interval with a step, "*/2" for example to perform the task on every odd month.
Note: These properties can be used with one of the following syntaxes:
  • <Variable Name>..<Property Name>
  • <Variable Name>.<Property Name>
Minimum required version
  • Version 15
This page is also available for…
Comments
Click [Add] to post a comment