PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Home | Sign in | English EN

This content has been translated automatically. Click here to view the French version.
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
Creates a scheduled task on an 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
// Recalculer les statistiques des fichiers de données de la base de données "MaBase",
// tous les samedis à 23H00
Optim is hScheduledOptimization
Optim.Description = "Recalcul des statistiques des fichiers de données" + ...
" de la base de données MaBase"
 
Optim.Scheduling.Month = "*"
Optim.Scheduling.DayOfWeek = "samedi"
Optim.Scheduling.Hour = "23"
Optim.Scheduling.Minute = "0"
 
Optim..File[1]..Name = "MaBase"
Optim..File[1]..Option = hOptStat
 
HAddScheduling(MaConnexion, Optim)
Syntax

Adding a scheduled task Hide the details

<Result> = HAddScheduling(<Connection> , <Scheduled task>)
<Result>: Boolean
  • True if the scheduled task was added,
  • False if an error occurred. HErrorInfo is used to identify the error.
<Connection>: String or Variable of type Connection
Connection for which a scheduled task must be added. This connection corresponds to:
<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> , <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>: String or Variable of type Connection
Connection for which a scheduled optimization task will be added. This connection corresponds to:
<Scheduled optimization task>: hScheduledOptimization variable
Name of the Variable of type hScheduledOptimization handled.

Adding a backup scheduling Hide the details

<Result> = HAddScheduling(<Connection> , <Scheduled backup>)
<Result>: Boolean
  • True if the scheduled backup was added,
  • False otherwise.
<Connection>: String or Variable of type Connection
Connection for which a scheduled backup will be added. This connection corresponds to:
<Scheduled backup>: hBackupDescription variable
Name of the Variable of type hBackupDescription handled.

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

<Result> = HAddScheduling(<Connection> , <Materialized view>)
<Result>: Boolean
  • True if the scheduling was added,
  • False otherwise.
<Connection>: String or Variable of type Connection
Connection for which a materialized view refresh scheduling must be added. This connection corresponds to:
<Materialized view>: hScheduleMaterializedView variable
Name of the hScheduleMaterializedView variable that contains the description of the materialized view to refresh.
Component: wd270hf.dll
Minimum version required
  • Version 20
This page is also available for…
Comments
Click [Add] to post a comment