|
|
|
|
|
|
|
|
|
|
HAddScheduling (Function)
 Disponible solo con este tipo de conexión
Adds a new scheduled item to an HFSQL server: scheduled task (stored procedure), backup, optimization or refresh of a materialized view.
Optim is hScheduledOptimization
Optim.Description = "Recalculating statistics of data files" + ...
" in MyDatabase"
Optim.Scheduling.Month = "*"
Optim.Scheduling.DayOfWeek = "Saturday"
Optim.Scheduling.Hour = "23"
Optim.Scheduling.Minute = "0"
Optim.File[1].Name = "MyDatabase"
Optim.File[1].Option = hOptStat
HAddScheduling(MyConnection, Optim)
Sintaxis
Adding a scheduled task Ocultar los detalles
<Result> = HAddScheduling(<Connection> , <Scheduled task>)
<Result>: Boolean - True if the scheduled task was added,
- False if an error occurs. HErrorInfo is used to identify the error.
<Connection>: Character string or Connection variable Connection for which a scheduled task must be added. This connection corresponds to: <Scheduled task>: hScheduledTask variable Name of the hScheduledTask variable describing the task that triggers a stored procedure.
Adding a scheduled optimization task Ocultar los detalles
<Result> = HAddScheduling(<Connection> , <Scheduled optimization task>)
<Result>: Boolean - True if the scheduled optimization task was added,
- False if an error occurs. HErrorInfo is used to identify the error.
<Connection>: Character string or Connection variable Connection for which a scheduled optimization task will be added. This connection corresponds to: <Scheduled optimization task>: hScheduledOptimization variable Name of the hScheduledOptimization variable used.
Adding a backup scheduling Ocultar los detalles
<Result> = HAddScheduling(<Connection> , <Scheduled backup>)
<Result>: Boolean - True if the scheduled backup was added,
- False otherwise.
<Connection>: Character string or Connection variable Connection for which a scheduled backup will be added. This connection corresponds to: <Scheduled backup>: hBackupDescription variable Name of the hBackupDescription variable used.
Adding a scheduling used to refresh a materialized view Ocultar los detalles
<Result> = HAddScheduling(<Connection> , <Materialized view>)
<Result>: Boolean - True if the scheduling was added,
- False otherwise.
<Connection>: Character string or Connection variable Connection for which a materialized view refresh scheduling must be added. This connection corresponds to: <Materialized view>: hScheduleMaterializedView variable Name of the hScheduleMaterializedView variable that contains the description of the materialized view to refresh.
Esta página también está disponible para…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|