PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP


New WINDEV, WEBDEV, WINDEV Mobile 25 feature!
  • Necessary rights
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
<Connection variable>.ListScheduling (Function)
In french: <Variable Connexion>.ListePlanification
HFSQL Client/ServerAvailable only with this kind of connection
Lists the scheduled tasks defined 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
// Describe the connection
MyDatabaseConnection is Connection
 
// Modify all scheduled backups
arrBckDesc is array dynamic of hBackupDescription
arrBckDesc = MyDatabaseConnection.ListScheduling(hlpBackup)
hBckDesc is hBackupDescription
FOR EACH hBckDesc OF arrBckDesc
IF hBckDesc..LimitNumberBackups = 3 THEN
hBckDesc..LimitNumberBackups = 5
MyDatabaseConnection.ModifyScheduling(hBckDesc)
END
END
Syntax
<Result> = <Connection>.ListScheduling(<Type of scheduling>)
<Result>: Array
Array containing the listed descriptions. The type of the array elements depends on <Type of scheduling>.
<Connection>: Connection variable
Name of the Connection variable that describes the connection to use.
<Type of scheduling>: Integer constant
Type of scheduling to list:
hlpOptimizationTasks for optimizing data files (re-indexing, calculation of statistics).
hlpBackupScheduling of backups.
hlpTaskScheduled tasks that run a stored procedure.
hlpMaterializedViewTasks for refreshing the materialized views.
Remarks
Versions 23 and later

Necessary rights

To list the tasks for refreshing materialized views or scheduled tasks, it is necessary to have the connection rights (constant hRightsConnection or hRightsEncryptedConnection) for each database that contains a view to process or a stored procedure to run.
To find out whether these rights are granted to a user or group, use <Connection variable>.InfoServerRights or <Connection variable>.InfoDatabaseRights.
To modify the rights granted to a user or group of users, use <Connection variable>.ModifyServerRights or <Connection variable>.ModifyDatabaseRights.
New in version 23

Necessary rights

To list the tasks for refreshing materialized views or scheduled tasks, it is necessary to have the connection rights (constant hRightsConnection or hRightsEncryptedConnection) for each database that contains a view to process or a stored procedure to run.
To find out whether these rights are granted to a user or group, use <Connection variable>.InfoServerRights or <Connection variable>.InfoDatabaseRights.
To modify the rights granted to a user or group of users, use <Connection variable>.ModifyServerRights or <Connection variable>.ModifyDatabaseRights.

Necessary rights

To list the tasks for refreshing materialized views or scheduled tasks, it is necessary to have the connection rights (constant hRightsConnection or hRightsEncryptedConnection) for each database that contains a view to process or a stored procedure to run.
To find out whether these rights are granted to a user or group, use <Connection variable>.InfoServerRights or <Connection variable>.InfoDatabaseRights.
To modify the rights granted to a user or group of users, use <Connection variable>.ModifyServerRights or <Connection variable>.ModifyDatabaseRights.
Component : wd250hf.dll
Minimum version required
  • Version 25
This page is also available for…
Comments
Click [Add] to post a comment