<Connection variable>.AddTask (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

HFSQL Client/Server functions

ActivateServerTrigger

AddGroup

AddLink

AddScheduledBackup

AddScheduledOptimization

DeactivateServerTrigger

DeleteScheduledBackup

DeleteScheduledOptimization

DescribeServerTrigger

ExecuteScheduledBackup

ListScheduledOptimization

ModifyDatabaseProperty

ModifyScheduledBackup

ModifyScheduledOptimization

NotifAddEmailRecipient

NotifConfigure

NotifDeleteCCRecipient

NotifDeleteEmailRecipient

NotifListCCRecipient

NotifListEmailRecipient

Necessary rights

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

<Connection variable>.AddTask (Function)

In french: <Variable Connexion>.AjouteTâche

Available only with this kind of connection

Adds a scheduled task on an HFSQL server.

Compatibility with version 12: For backward compatibility with version 12, you also have the ability to define a task via the HScheduledTask structure. This task will run the specified stored procedure (or will perform a database backup).

Example

// Describe the connection
gsCSConnection is Connection

MyTask is hScheduledTask
MyTask.Description = "Scheduled backup " + CR + ...
DateToString(DateSys(), maskDateSystem) + ...
" at" + TimeToString(TimeSys(), "HH:MM:SS")
MyTask.Month = "*"
MyTask.DayOfWeek = "*"
MyTask.DayOfMonth = "*"
MyTask.Hour = EDT_Time.Hour
MyTask.Minute = EDT_Time.Minute
MyTask.NumberExecution = 1
MyTask.Procedure = "HBackup"
Add(MyTask.Parameter, gsNameCSDatabase + "/LOG_TASKSFIC")
Add(MyTask.Parameter, gsNameCSDatabase + ".ScheduledBackup")
Add(MyTask.Parameter, True)
Add(MyTask.Parameter, MyTask.Description)
nID is int = gsCSConnexion.AddTask(MyTask)

Syntax

Creating a task from an hScheduledTask variable Hide the details

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

<Result>: Integer

Identifier of scheduled task,
-1 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 task must be added.

<Scheduled task>: hScheduledTask variable

Name of the hScheduledTask variable used.

Creating a task from the hScheduledTask structure (compatibility with version 12) Hide the details

<Result> = <Connection>.AddTask(<Stored procedure> [, <Parameter 1> [... [, <Parameter N>]]])

<Result>: Character string

Identifier of scheduled task,
-1 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 task must be added.

<Stored procedure>: WLanguage procedure

Name of WLanguage stored procedure that will be run when triggering the task. This parameter has the following format: "<Database name>\<Name of stored procedure>". If this name corresponds to "HBackup", the scheduled task will perform a backup.

<Parameter 1>: Type of optional parameter

Parameter that will be passed to the stored procedure. In the case of a backup, the parameters to be passed are those of <Connection variable>.Backup, except for the connection.

<Parameter N>: Type of optional parameter

Parameter that will be passed to the stored procedure. In the case of a backup, the parameters to be passed are those of <Connection variable>.Backup, except for the connection.

Remarks

Necessary rights

To add a task, you must have:

the corresponding rights (hRightsManageTask constant) on the server,
the rights to connect (hRightsConnection or hRightsEncryptedConnection) to each relevant database,
the rights to run the command linked to the scheduled task.

The task will be run with the account of user who created the task.

Caution: The scheduled task will not be performed if the server is switched off. The scheduled task will be performed at the next available date when the server is switched on.

Component: wd270hf.dll