PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK

This content comes from an automatic translation.
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
HModifyScheduling (Function)
In french: HModifiePlanification
HFSQL Client/ServerAvailable only with this kind of connection
Modifies 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
// Delete all scheduled backups
arrBckDesc is array dynamic of hBackupDescription
arrBckDesc = HListScheduling(MyDatabaseConnection, hlpBackup)
hBckDesc is hBackupDescription
FOR EACH hBckDesc OF arrBckDesc
IF hBckDesc..LimitNumberBackups = 3 THEN
hBckDesc..LimitNumberBackups = 5
HModifyScheduling(MyDatabaseConnection, hBckDesc)
END
END
Syntax

Modifying a scheduled task Hide the details

<Result> = HModifyScheduling(<Connection> , <Scheduled task>)
<Result>: Boolean
  • True if the scheduled task was modified,
  • False if an error occurred. HErrorInfo is used to identify the error.
<Connection>: Character string (with or without quotes) or Connection variable
Connection for which a scheduled task is to be modified. This connection corresponds to:
<Scheduled task>: hScheduledTask variable
Name of hScheduledTask variable describing the task that triggers a stored procedure.

Modifying a scheduled optimization task Hide the details

<Result> = HModifyScheduling(<Connection> , <Scheduled optimization task>)
<Result>: Boolean
  • True if the scheduled optimization task was modified
  • False if an error occurred. HErrorInfo is used to identify the error.
<Connection>: Character string (with or without quotes) or Connection variable
Connection for which a scheduled optimization task must be modified. This connection corresponds to:
<Scheduled optimization task>: hScheduledOptimization variable
Name of hScheduledOptimization variable used.

Modifying a backup scheduling Hide the details

<Result> = HModifyScheduling(<Connection> , <Scheduled backup>)
<Result>: Boolean
  • True if the scheduled backup was modified,
  • False otherwise.
<Connection>: Character string (with or without quotes) or Connection variable
Connection for which a scheduled backup must be modified. This connection corresponds to:
<Scheduled backup>: hBackupDescription variable
Name of the variable of type hBackupDescription manipulated.

Modifying a scheduling for refreshing a materialized view Hide the details

<Result> = HModifyScheduling(<Connection> , <Materialized view>)
<Result>: Boolean
  • True if the scheduling was modified,
  • False otherwise.
<Connection>: Character string (with or without quotes) or Connection variable
Connection for which a materialized refresh planning must be modified. This connection corresponds to:
<Materialized view>: hScheduleMaterializedView variable
Name of the hScheduleMaterializedView variable containing the description of the materialized views to refresh.
Component : wd250hf.dll
Minimum version required
  • Version 20
This page is also available for…
Comments
Click [Add] to post a comment