PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK

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
Creates a scheduled task on a HFSQL server:
  • stored procedure,
  • backup,
  • optimization,
  • refresh of materialized view.
Versions 22 and later
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
New in version 22
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
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" + ...
" in  MyDatabase"
 
Optim..Scheduling..Month = "*"
Optim..Scheduling..DayOfWeek = "Saturday"
Optim..Scheduling..Hour = "23"
Optim..Scheduling..Minute = "0"
 
Optim..File[1]..Name = "MyDatabase"
Optim..File[1]..Option = hOptStat
 
HAddScheduling(MyConnection, Optim)
Syntax

Adding a scheduled task Hide the details

<Result> = HAddScheduling(<Connection name> , <Scheduled task>)
<Result>: Boolean
  • True if the scheduled task was added,
  • False if an error occurred. HErrorInfo is used to identify the error.
<Connection name>: Character string (with or without quotes)
Name of connection for which a scheduled task will be added. This connection was defined in the data model editor, or by HDescribeConnection or HOpenConnection.
<Scheduled task>: hScheduledTask variable
Name of hScheduledTask variable describing the task that triggers a stored procedure.

Adding a scheduled optimization task Hide the details

<Result> = HAddScheduling(<Connection name> , <Scheduled optimization task>)
<Result>: Boolean
  • True if the scheduled optimization task was added,
  • False if an error occurred. HErrorInfo is used to identify the error.
<Connection name>: Character string (with or without quotes)
Name of connection for which a scheduled optimization task will be added. This connection was defined in the data model editor, or by HDescribeConnection or HOpenConnection.
<Scheduled optimization task>: hScheduledOptimization variable
Name of hScheduledOptimization variable used.

Adding a backup scheduling Hide the details

<Result> = HAddScheduling(<Connection name> , <Scheduled backup>)
<Result>: Boolean
  • True if the scheduled backup was added,
  • False otherwise.
<Connection name>: Character string (with or without quotes)
Name of connection for which a scheduled backup will be added. This connection was defined in the data model editor, or by HDescribeConnection or HOpenConnection.
<Scheduled backup>: hBackupDescription variable
Name of hBackupDescription variable used.

Adding a scheduling used to refresh a materialized view Hide the details

<Result> = HAddScheduling(<Connection name> , <Materialized view>)
<Result>: Boolean
  • True if the scheduling was added,
  • False otherwise.
<Connection name>: Character string (with or without quotes)
Name of the connection for which a refresh scheduling must be added. This connection was defined in the data model editor, or by HDescribeConnection or HOpenConnection.
<Materialized view>: hScheduleMaterializedView variable
Name of the hScheduleMaterializedView variable containing the description of the materialized views to refresh.
Component : wd240hf.dll
Minimum version required
  • Version 20
This page is also available for…
Comments
Click [Add] to post a comment