|
|
|
|
|
|
|
|
|
|
- Properties specific to hScheduling variables
hScheduling (Type of variable) In french: hPlanification
 Available only with this kind of connection
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.
- for a scheduled replication of HFSQL servers.
The characteristics of this scheduling can be defined and changed using different WLanguage properties. This type of variable is used: Remark: For more details on the declaration of this type of variable and the use of WLanguage properties, see Declaring a variable.
// Recalculate statistics of files 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 hScheduling variables The following properties can be used to handle a scheduling: | | | | Property name | Type used | Effect |
|---|
| DayOfMonth | Character string | Number 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.
| | DayOfMonthOrDayOfWeek | Boolean | Used 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).
| | DayOfWeek | Character string | Number 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").
| | Hour | Character string | Execution time of scheduled task. If TimeUTC is set to True, this time will be in UTC. 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.
| | Minute | Character string | Minutes of the execution time of the scheduled task. If TimeUTC is set to True, this time will be in UTC. 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.
| | Month | Character string | Number 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.
| | TimeUTC | Boolean | - True (default value) if the time is in UTC (Hour and Minute properties),
- False otherwise.
|
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|