PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • 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
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
// Modify all scheduled backups
arrBckDesc is array dynamic of hBackupDescription
arrBckDesc = HListScheduling(MyDatabaseConnection, hlpBackup)
hBckDesc is hBackupDescription
FOR EACH hBckDesc OF arrBckDesc
IF hBck..LimitNumberBackups = 3 THEN
hBck..LimitNumberBackups = 5
HModifyScheduling(MyDatabaseConnection, hBck)
END
END
Syntax
<Result> = HListScheduling(<Connection Name> , <Type of Scheduling>)
<Result>: Array
Array containing the listed descriptions. The type of the array elements depends on <Type of Scheduling>.
<Connection Name>: Character string (with or without quotes)
Name of connection to use. This connection was defined in the data model editor, or by HDescribeConnection or HOpenConnection.
<Type of Scheduling>: Integer constant
Type of scheduling to list:
hlpOptimizationTasks for optimizing files (reindexing, statistical calculation).
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 refresh tasks of materialized views or the scheduled tasks, you must have the rights to connect ('hRightsConnection' or hRightsEncryptedConnection constant) to each relevant database, which means for each database containing a view to process or a stored procedure to run.
To find out whether these rights are granted to a user or to a group, use HInfoServerRights or HInfoDatabaseRights.
To modify the rights granted to a user or to a group of users, use HModifyServerRights or HModifyDatabaseRights.
New in version 23

Necessary rights

To list the refresh tasks of materialized views or the scheduled tasks, you must have the rights to connect ('hRightsConnection' or hRightsEncryptedConnection constant) to each relevant database, which means for each database containing a view to process or a stored procedure to run.
To find out whether these rights are granted to a user or to a group, use HInfoServerRights or HInfoDatabaseRights.
To modify the rights granted to a user or to a group of users, use HModifyServerRights or HModifyDatabaseRights.

Necessary rights

To list the refresh tasks of materialized views or the scheduled tasks, you must have the rights to connect ('hRightsConnection' or hRightsEncryptedConnection constant) to each relevant database, which means for each database containing a view to process or a stored procedure to run.
To find out whether these rights are granted to a user or to a group, use HInfoServerRights or HInfoDatabaseRights.
To modify the rights granted to a user or to a group of users, use HModifyServerRights or HModifyDatabaseRights.
Components
WINDEVWEBDEV - Server codeReports and Queries wd230hf.dll
Linux wd230hf.so
See also
Minimum required version
  • Version 20
This page is also available for…
Comments
Click [Add] to post a comment