<Connection variable>.ModifyScheduling (Function)

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Version:

Home | Sign in | English

HFSQL Client/Server functions

ExecuteScheduledBackup

AddGroup

AddLink

AddScheduledBackup

AddScheduledOptimization

DeleteScheduledBackup

DeleteScheduledOptimization

ListScheduledOptimization

ModifyDatabaseProperty

ModifyScheduledBackup

ModifyScheduledOptimization

NotifAddEmailRecipient

NotifDeleteCCRecipient

NotifDeleteEmailRecipient

NotifListCCRecipient

NotifListEmailRecipient

HAddScheduledOptimization

HCS.Timeout (Variable)

HDeleteScheduledBackup

HDeleteScheduledOptimization

HExecuteScheduledBackup

HExecuteScheduling

HInfoBackup

HInfoDatabaseProperty

HListScheduledOptimization

HModifyDatabaseProperty

HModifyDatabaseRights

HModifyFileProperty

HModifyFileRights

HModifyGroup

HModifyScheduledBackup

HModifyScheduledOptimization

HModifyScheduling

HModifyServerProperty

HNotifAddEmailRecipient

HNotifConfigure

HNotifDeleteCCRecipient

HNotifDeleteEmailRecipient

HNotifListCCRecipient

HNotifListEmailRecipient

New WINDEV, WEBDEV, WINDEV Mobile 25 feature!

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

<Connection variable>.ModifyScheduling (Function)

In french: <Variable Connexion>.ModifiePlanification

Available 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

This function is now available in Universal Windows 10 App mode.

New in version 22

This function is now available in Universal Windows 10 App mode.

Example

// Describe the connection
MyDatabaseConnection is Connection

// Delete 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

Modifying a scheduled task Hide the details

<Result> = <Connection>.ModifyScheduling(<Scheduled task>)

<Result>: Boolean

True if the scheduled task was modified,
False if an error occurred. HErrorInfo is used to identify the error.

<Connection>: Connection variable

Name of the Connection variable that describes the connection for which a scheduled task must be modified.

<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> = <Connection>.ModifyScheduling(<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>: Connection variable

Name of the Connection variable that describes the connection for which a scheduled optimization task must be modified.

<Scheduled optimization task>: hScheduledOptimization variable

Name of the hScheduledOptimization variable used.

Modifying a backup scheduling Hide the details

<Result> = <Connection>.ModifyScheduling(<Scheduled backup>)

<Result>: Boolean

True if the scheduled backup was modified,
False otherwise.

<Connection>: Connection variable

Name of the Connection variable that describes the connection for which a scheduled backup must be modified.

<Scheduled backup>: hBackupDescription variable

Name of the hBackupDescription variable used.

Modifying a scheduling for refreshing a materialized view Hide the details

<Result> = <Connection>.ModifyScheduling(<Materialized view>)

<Result>: Boolean

True if the scheduling was modified,
False otherwise.

<Connection>: Connection variable

Name of the Connection variable that describes the connection for which a materialized view refresh scheduling must be modified.

<Materialized view>: hScheduleMaterializedView variable

Name of the hScheduleMaterializedView variable containing the description of the materialized views to refresh.

Component : wd250hf.dll